Oracle
1Z0-883 · Question #103
1Z0-883 Question #103: Real Exam Question with Answer & Explanation
Sign in or unlock 1Z0-883 to reveal the answer and full explanation for question #103. The question stem and answer options stay visible for context.
Question
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?
Options
- ASTOP SLAVE; CHANGE MASTER TO MASTER_DELAY=0; START SLAVE;
- BSTOP SLAVE; CHANGE MASTER TO MASTER_DELAY =0,
- CSTOP SLAVE; CHANGE MASTER TO RELAY_LOG_FILE = `hostname-relay-bin.00004',
- DSTOP SLAVE; SET GLOBAL master_delay =0; START SLAVE;
Unlock 1Z0-883 to see the answer
You've previewed enough free 1Z0-883 questions. Unlock 1Z0-883 for full answers, explanations, the timed quiz mode, progress tracking, and the master PDF. Question stem and options stay visible so you can still see what's on the exam.