Big 11.11 Sale Limited Time 70% Discount Offer - Ends in 0d 00h 00m 00s - Coupon code: simple70

  1. Home
  2. Discussions
  3. Oracle
  4. MySQL Database Administration
  5. 1z0-888 Discussions
  6. 1z0-888 Exam Topic 3 Question 23 Discussion

Oracle MySQL 5.7 Database Administrator 1z0-888 Question # 23 Topic 3 Discussion

 Oracle Discussions      Browse All Questions      Go to Exam Detail      Get Premium Access
 Previous
Next  

Oracle MySQL 5.7 Database Administrator 1z0-888 Question # 23 Topic 3 Discussion

1z0-888 Exam Topic 3 Question 23 Discussion:
Question #: 23
Topic #: 3

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-relay-bin.00004’, RELAY_LOG_POS = 1383;

Get Premium 1z0-888 Questions
Actual exam question for Oracle 1z0-888 exam by Hale53561 at Nov 10, 2025, 3:40:04 PM

Contribute your Thoughts:


Chosen Answer:
This is a voting comment (?). It is better to Upvote an existing comment if you don't have anything to add.

Submit
 Previous
Next