A master-slave replication setup has the slave showing this error:

On the master server, the binary logs show:

What could explain this error? (Choose two.)

A. binlog_cache_size=1024 is too small and transactions are lost.

B. binlog_format=STATEMENT and a non-deterministic query was executed.

C. enforce_gtid_consistency=ON and consistency is broken between the master and the slave.

D. The sync_relay_log=1000 setting on the slave is too small.

E. sync_binlog=0 and the master server crashed.

An existing master-slave setup is currently using a delayed replication of one hour. The master has crashed and the slave must be "rolled forward" to provide all the latest data.

The SHOW SLAVE STATUS indicates these values: RELAY_LOG_FILE=hostname-relay-bin.00004 RELAY_LOG_POS=1383

Which command set would make the slave current?

A. STOP SLAVE; SET GLOBAL master_delay=0; START SLAVE;

B. STOP SLAVE; CHANGE MASTER TO RELAY_LOG_FILE = `hostname-relay-bin.00004', RELAY_LOG_POS = 1383;

C. STOP SLAVE; CHANGE MASTER TO MASTER_DELAY=0; START SLAVE;

D. STOP SLAVE; CHANGE MASTER TO MASTER_DELAY=0; RELAY_LOG_FILE = `hostname-relaybin.00004', RELAY_LOG_POS = 1383;

Which statement best describes the purpose of the InnoDB buffer pool?

A. It is amount of buffers available during a transaction.

B. It caches only the indexes for InnoDB tables.

C. It caches data and indexes for InnoDB tables.

D. It holds changes made during a transaction before they are written to the log.

E. It is a pool of memory for SQL query sort operations from within the InnoDB engine.

Where does MySQL Linux RPM install the mysqld binary?

A. /usr/libexec/

B. /usr/local/mysql/bin/

C. /usr/sbin/

D. /usr/bin/

E. /opt/mysql/server/bin/

The MySQL user `adam' currently has USAGE permissions to the database.

The football database is transactional and has non-stop updates from application users. The `adam' user needs to be able to take consistent backups of the football database by using the ?single-transaction option.

Which extra GRANT permissions are required for adam to take mysqldump backups?

A. The `adam' user must also have SINGLE TRANSACTION global grant to take a consistent backup.

B. The `adam' user needs the PROCESS privilege to be able to take a consistent backup while other users are connected.

C. The `adam' user must have the SUPER privilege in order to take data backups.

D. The `adam' user must also have SELECT on the football database for backup to work.