Oracle Exam 1Z0-888 Topic 5 Question 48 Discussion

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

Question #: 48
Topic #: 5

A simple master-to-slave replication is currently being used. This information is extracted from the SHOW SLAVE STATUS output:

You execute a 'SHOW CREATE TABLE mytable'' on the slave:

The table mytable on the slave contains:

You have issued a STOP SLAVE command. You have determined that it is safe to skip the transaction in this case. One or more statements are required before you can issue a START SLAVE command to resolve the duplicate key error. Which statement should be used?

ASET GTID_NEXT=''CONSISTENCY'';BEGIN; COMMIT;SET GTID_NEXT=''AUTOMATIC'';

BSETGTID_NEXT=''5da6b4f5-6f60-11e8-b2d6-0010e05f3e06:8'';BEGIN;COMMIT;SET GTID_NEXT=''AUTOMATIC'';

CSET GLOBAL SQL_SKIP_SLAVE_COUNTER=1

DSET GLOBAL enforce_gtid_consistency=ON

ESET GTID_EXECUTED=''5da6b4f5-6f60-11e8-b2d6-0010e05f3e06:8'';
References:

Show Suggested Answer

Suggested Answer: C

by Larae at May 04, 2022, 07:06 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!