Oracle MySQL 5.6 Database Administrator - 1z1-883

ROW-based replication has stopped working. You investigate the error log file and find the following entries:
2013-08-27 14:15:47 9056 [ERROR] Slave SQL: Could not execute Delete_rows event on table test.t1; Can't find record in 't1', Error_code: 1032; handler error
HA_ERR_KEY_NOT_FOUND; the event's master log 56_master-bin. 000003, end_log_pos 851, Error_code: 1032
2013-08-27 14:15:47 9056 [warning] Slave: Can't find record in 't1' Error_code: 1032
2013-08-27 14:15:47 9056 [ERROR] Error running query, slave SQL thread aborted. Fix the problem, and restart the slave SQL thread with "SLAVE START". We stopped at log '56_masterbin. 000003' position 684
Why did you receive this error?

• A. The table definition on the slave -litters from the master.
• B. The slave SQL thread does not have DELETE privileges to execute on test.t1 table.s
• C. Multi-threaded replication slaves can have temporary errors occurring for cross database updates.
• D. The slave SQL thread attempted to remove a row from the test.t1 table, but the row did not exist.

You need to replicate a table from a master to a slave. The master and slave copies of the table will have different number of columns.
Which two conditions must be true?

• A. The master database cannot have more columns than the slave. Only the slave deatbase can have more columns.
• B. Columns that are common to both versions of the table must come first in the table definition, before any additional columns are additional columns are defined on either server.
• C. Columns that are common to both versions of the table must be defined in the same order on the master and the slave.
• D. The slave database cannot have more columns than the master. Only the master database can have more columns.
• E. Each extra column in the copy with more columns must not have a default value.

Which three statements are true about memory buffer allocation by a MySQL Server?

• A. User buffers are allocated at server startup and freed when the user is dropped.
• B. All dynamic buffers that are set with a SET GLOBAL statement immediately get allocated globally, and are never freed.
• C. Global buffers such as the InnoDB buffer pool are allocated after the server starts, and are never freed.
• D. Buffers that are needed for certain operation are allocated when the operation starts, and freed when it ends.
• E. Thread buffers are allocated when a client connects, and are freed when the client disconnects.

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 the following values:
RELAY_LOG_FILE = hostname-relay-bin.00004
RELAY_LOG_POS = 1383
Which command set would make the slave current?

• A. STOP SLAVE; CHANGE MASTER TO MASTER_DELAY =0, RELAY_LOG_FILE = 'hostnamerelay-bin.00004' , RELAY_LOG_POS = 1383;
• B. STOP SLAVE; SET GLOBAL master_delay =0; START SLAVE;
• C. STOP SLAVE; CHANGE MASTER TO RELAY_LOG_FILE = 'hostname-relay-bin.00004', RELAY_LOG_POS = 1383;
• D. STOP SLAVE; CHANGE MASTER TO MASTER_DELAY=0; START SLAVE;

Which three methods will show the storage engine for the Country table?

• A. SELECT ENGINE FROM INFORMATION_SCHEMA.ENGINES WHERE TABLE_NAME= 'Country';
• B. SHOW TABLE STATUS LIKE 'Country';
• C. SELECT ENGINE FROM INFORMATION_SCHEMA.TABLES WHERE TABLE_NAME= 'Country';
• D. SHOW ENGINE Country STATUS;
• E. SHOW CREATE TABLE Country;