1Z0-888 試験問題を無料オンラインアクセス

You are investigating the performance of a query which selects data from an InnoDB table.
Consider this Performance Schema diagnostics output for the query:

Which statement is true about the output?

• A.The time the query took is the sum of all timer_wait values.
• B.The query did not find its table in the table definition cache.
• C.The query read data from the data file rather than directly from the buffer pool.
• D.The event with event_id = 8945 is a child of the event with event_id=8944.

You have a MySQL instance with the following variables in the /etc/my.cnf file:

You issue these statements:
USE prices;
UPDATE sales.january SET amount=amount+1000;
An hour after excluding the statements, you realize that you made a mistake and you want to go to the binary log and look at the statements again.
Which statement is true? (Choose two.)

• A.Nothing is logged because you are executing an UPDATE statement that will cause changes to more than one row, and you do not have the --binlog-format value set to STATEMENT.
• B.The changes caused by the UPDATE statement are logged to the binary log because the instance is using --binlog-format = ROW
• C.Nothing was written to the binary log because you cannot perform a calculation in a query without enclosing the statement in single quotation marks.
• D.You would receive an error on the statement because you cannot update a different database that what is specified with the USE statement.
• E.The statement would fail because you cannot update more than one row at a time when using ?
  binlogformat = ROW.

There are multiple instances of MySQL Server running on a single OS that is backed up using the mysqlbackup command.
The /etc/my/cnf contains default values, for example, datadir=/var/lib/mysql/, with extra instances having their own separate my.cnf file (for example /etc/mysql/instanceN.cnf) overriding the defaults. A restore of the second instance is attempted from the mysqlbackup archive using this command:
mysqlbackup --backup-dir=/opt/backup/mysql/instance2 copy-back
Upon starting the second MySQL instance, you notice that the data does not match the expected backup.
Which command-line option is required to successfully update the second instance?

• A.--backup-instance=/var/lib/mysql/instance2
• B.--restore=2
• C.--defaults-file=/etc/mysql/instance2.cnf
• D.--copy-back-from-log
• E.--instance=/var/lib/mysql/instance2

You have a MySQL replication setup and you intentionally stop the SQL thread on the slave.

What are two reasons that you may stop the SQL thread on the slave while keeping the I/O thread running?

• A.to allow a backup to be created under reduced load
• B.to allow for point-in-time recovery on the slave
• C.to prevent schema changes from propagating to the slave before they are validated
• D.to allow the remaining events to be processed on the slave while not receiving new events from the master
• E.to prevent any transaction experiencing a deadlock

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?

• A.It is an alternative to storing the MySQL login details in a my.cnf file.
• B.A .mylogin.cnf file can be edited using a text editor, such as vim or Notepad++.
• C.It provides means to help avoid accidentally exposing the MySQL login details.
• D.It provides a FIPS-compliant keyring for storing MySQL login details.
• E.A .mylogin.cnf file can store at most one login path.
• F.mysql_config_editor is the only MySQL-provided utility that can print the values stored in .mylogin.cnf.