Question 1

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

Options :

A : all updates except to the TEMPDB database

B : all updates except to the PERFORMANCE_SCHEMA database

C : all updates not involving temporary tables

D : all updates to the default database, except temporary tables

E : all updates to all databases

Answer: A

Question 2

Your MySQL environment has asynchronous position based-replication with one master and one slave.The slave instance had a disk I/O problem, so it was stopped.You determined that the slave relay log files were corrupted and unusable, but no other files are damaged.You restart MySQL Server.How can replication be restored?

Options :

A : The slave relay logs should be deleted; then execute START SLAVE;

B : The relay logs from the master should be used to replace the corrupted relay logs.

C : The slave relay logs should be deleted; execute CHANGE MASTER to adjust the replication relay log file name, then issue start SLAVE;

D : The slave needs to be restored from backup.

Answer: B

Question 3

Which statement is true about FLUSH LOGS command?

Options :

A : It requires the RELOAD, FILE, and DROP privileges.

B : It closes and reopens all log files.

C : It closes and sends binary log files to slave servers.

D : It flushes dirty pages in the buffer pool to the REDO logs.

Answer: B

Question 4

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 :

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

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

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

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

Answer: B,C

Question 5

You adjust a default configuration to the following /etc/my.cnf on a Linux installation:[mysqld]Loq-binBinrylog_format=ROWYou do not notice the spelling error in binrylog_format and restart your production server.How does the MySQL server behave with incorrectly spelled options?

Options :

A : Mysqld uses internal configuration versioning and reverts to the previous configuration.

B : When using mysql_config_editor for configuration adjustments, it detects incorrect syntax and typing mistakes.

C : The mysqld_safe script skips the unknown variable and starts using the remaining configuration changes.

D : Mysqld prints to the error log about an unknown variable, and then exits.

Answer: D