1z0-888 Free Practice Test

You enable binary logging on MySQL Server with the configuration: binlog-format=STATEMENT log-bin
Which database updates are logged on the master server to the binary log by default?

1. A. all updates except to the TEMPDB database
2. B. all updates except to the PERFORMANCE_SCHEMA database
3. C. all updates not involving temporary tables
4. D. all updates to the default database, except temporary tables
5. E. all updates to all databases

Correct Answer: D

What is the best method for monitoring Group Replication conflict resolution?

1. A. the PERFORMANCE_SCHEMA tables
2. B. the SHOW PROCESSLIST command
3. C. the INNODB Lock Monitor details
4. D. the SHOW STATUS command
5. E. the INFORMATION_SCHEMA tables

Correct Answer: A

Consider the CHECK TABLE command.
In which two situations should this command be used? (Choose two.)

1. A. to find out why a query takes a long time to execute on a given table
2. B. to make sure a table has no structural problems
3. C. to improve performance by updating index distributing statistics on InnoDB tables
4. D. to repair table structure problem
5. E. to make sure that no table indexes are corrupted

Correct Answer: BE
The CHECK TABLE statement performs an integrity check on table structure and contents. It works for MyISAM and InnoDB tables. For MyISAM tables, it also updates the index statistics. If the table is a view, CHECK TABLE verifies the view definition. If the output from CHECK TABLE indicates that a table has problems, the table should be repaired.

Examine the mysqldumpslow output:
<>

1. A. There is network congestion between client and server.
2. B. No index has been defined on the filtered column.
3. C. There are 108 queries still being executed.
4. D. A table lock is causing delays.
5. E. A full table scan is being use

Correct Answer: AE

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

1. A. You would receive an error on the statement because you cannot update a different database that what is specified with the USE statement.
2. B. The changes caused by the UPDATE statement are logged to the binary log because the instance is using --binlog-format = ROW
3. C. The statement would fail because you cannot update more than one row at a time when using –binlogformat = ROW.
4. D. 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.
5. E. Nothing was written to the binary log because you cannot perform a calculation in a query without enclosing the statement in single quotation marks.

Correct Answer: DE