Master the Oracle 1z0-888 Exam: Essential Study Tips and Strategies

Questions 1

The MySQL installation includes the mysql_config_editor utility for managing login paths stored in a .mylogin.cnf file.

Which two are true about the login path feature? (Choose two.)

Options:

mysql_config_editor is the only MySQL-provided utility that can print the values stored in .mylogin.cnf.

A .mylogin.cnf file can store at most one login path.

It provides a FIPS-compliant keyring for storing MySQL login details.

A .mylogin.cnf file can be edited using a text editor, such as vim or Notepad++.

It is an alternative to storing the MySQL login details in a my.cnf file.

It provides means to help avoid accidentally exposing the MySQL login details.

Buy Now

Questions 2

You are setting up a new installation of MySQL Server 5.7 (a GA release.) You have used a ZIP or TAR package to ensure that the mysqld binary, along with its support files, such as plug-ins and error messages, now exist on the host. Assume that the default datadir exists on the host. You installed the binary in the default location (the default --basedir value) for your operating system.

Which step should you perform before defining your own databases and database tables?

Options:

Execute a command with a minimal form of: mysql --initialize

Create a configuration file containing default-storage-engine=InnoDB.

Set an exception in the host machine’s firewall to allow external users to talk to mysqld.

Create additional login accounts (so that everyone does not need to log in as root) and assign them appropriate privileges.

Buy Now

Questions 3

A single InnoDB table has been dropped by accident. You are unable to use an additional intermediate MySQL instance to restore the table. Which two backup methods can be used to restore the single table without stopping the MySQL instance? (Choose two.)

Options:

a backup created with mysqldump --all-databases

a backup created using FLUSH TABLES … FOR EXPORT

an up-to-date replication slave

a file system-level snapshot

a file system copy created while MySQL was shut down.

Buy Now

Questions 4

You have just executed a manual backup by using this command:

mysqlbackup –u root –p –-socket=/tmp/my.sock –-backup-dir=/my/backup/ backup

The operation completed without error.

What is the state of this backup and operation required before it is ready to be restored?

Options:

Backup State = Compressed Backup

Operation = copy-back

Backup State = Raw Backup

Operation = apply-log

Backup State = Prepared Backup

Operation = validate

Backup State = Prepared Backup

Operation = apply-log

Backup State = Raw Backup

Operation = backupdir-to-image

Buy Now

Questions 5

On a master server that is using statement-based replication, a table of log data has become very large.

You decide to delete 100,000 rows.

Which two methods can be independently invoked to ensure that the delete is properly propagated to the slave? (Choose two.)

Options:

Change the replication mode to MIXED before issuing any delete statements when the LIMIT clause is used.

If the data modification is non-deterministic, the query optimizer will resolve any potential issues.

Use the LIMIT clause to limit the deletion to 100,000 rows.

Use the LIMIT clause in conjunction with the ORDER BY clause.

Buy Now

Questions 6

Which two methods will provide the total number of partitions on a table? (Choose two.)

Options:

Query the INFORMATION_SCHEMA.PARTITIONS table

Use the command: SHOW TABLE STATUS

Query the performance_schema.objects_summary_global_by_type table

Query the INFORMATION_SCHEMA.TABLES table for the partition_count

Use the command: SHOW CREATE TABLE

Buy Now

Questions 7

Which two options describe how MySQL Server allocates memory? (Choose two.)

Options:

Each connection may have its own per-thread memory allocations.

Thread memory is pre-allocated up to thread_cache_size for performance.

Each thread allocates memory from a global pool.

Global memory resources are allocated at server startup.

Buy Now

Questions 8

Examine the mysqldumpslow output:

1z0-888 Question 8

Which two options could explain the slow query? (Choose two.)

Options:

There is network congestion between client and server.

No index has been defined on the filtered column.

There are 108 queries still being executed.

A table lock is causing delays.

A full table scan is being used.

Buy Now

Questions 9

Which statement is correct about how InnoDB storage engine uses disk space?

Options:

It stores data in .MYD files and its index and undo information in the common tablespace.

It stores data in .MYD files, index information in .MYI files, and undo information the common tablespace.

It stores its data in tablespace file(s). Index and data dictionary details are stored in .FRM files.

It stores its data, index and undo information in .MYD and .MYI files.

It stores data, index and undo information in tablespace file(s).

Buy Now

Questions 10

After rebooting the host, you attempt to start the mysqld service. You get the following error:

Can’t start the server: Bind on TCP/IP port: Address already in use

What is the most likely cause of this error?

Options:

The mysqld service has already been started on the same port.

The network service process in the server is frozen, so all TCP/IP connections are paused and cannot be reused.

You failed to specify the port number 3306 to the command to start the server, so it is defaulting to port 80, which is in use by the built-in web server.

The /etc/hosts file does not have a valid IP entry for mysqld localhost, so it is binding to 127.0.0.1, which is already in use.

The mysql.sock file in the MySQL /tmp directory was not removed after the reboot, so mysqld still thinks there is an active server running.

Buy Now

Exam Code: 1z0-888

Exam Name: MySQL 5.7 Database Administrator

Last Update: Dec 2, 2024

Questions: 124