Free Oracle 1z1-883 Exam Dumps Questions & Answers

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 RELAY_LOG_FILE = 'hostname-relay-bin.00004', RELAY_LOG_POS = 1383;
• B.  STOP SLAVE; SET GLOBAL master_delay =0; START SLAVE;
• C.  STOP SLAVE; CHANGE MASTER TO MASTER_DELAY =0, RELAY_LOG_FILE = 'hostnamerelay-bin.00004' , RELAY_LOG_POS = 1383;
• D.  STOP SLAVE; CHANGE MASTER TO MASTER_DELAY=0; START SLAVE;

Which two statements are true about setting the per-thread buffers higher than required?

• A.  It requires increasing the thread_cache_size variable.
• B.  It can affect system stability during peak load times, due to swapping.
• C.  It causes increased overhead due to initial memory allocation.
• D.  More memory per thread is beneficial in all scenarios.

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

Which statement is true about the log-output variable?

• A.  It sets the target location for the binary logs generated by the MySQL sever.
• B.  It specifies output destinations for the slow and General Query logs.
• C.  It enables and starts the General Query Log.
• D.  It is a static variable and can be set only at MySQL server startup.

You examine the output of SHOW GLOBAL STATUS and notice that the value of Created_tmp_disk_tables is consistently increasing.
Which two variables would likely fix this issue?

• A.  Table_open_cache_instancs
• B.  Max_heap_table_size
• C.  Table_open_cache
• D.  Table_definition_cache
• E.  Max_tmp_tables
• F.  Tmp_table_size