Oracle Exam 1Z0-888 Topic 6 Question 49 Discussion

Actual exam question for Oracle's 1Z0-888 exam

Question #: 49
Topic #: 6

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?

ASTOP SLAVE; SET GLOBAL master_delay=0; START SLAVE;

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

CSTOP SLAVE; CHANGE MASTER TO MASTER_DELAY=0; START SLAVE;

DSTOP SLAVE; CHANGE MASTER TO MASTER_DELAY=0; RELAY_LOG_FILE = 'hostname-relay-bin.00004', RELAY_LOG_POS = 1383;

Show Suggested Answer

Suggested Answer: C

by Jina at May 09, 2022, 02:13 PM

Limited Time Offer

25%

Off

Get Premium 1Z0-888 Questions as Interactive Web-Based Practice Test or PDF

Contribute your Thoughts:

Submit Cancel

Currently there are no comments in this discussion, be the first to comment!