Oracle
1Z0-908 · Question #76
1Z0-908 Question #76: Real Exam Question with Answer & Explanation
Sign in or unlock 1Z0-908 to reveal the answer and full explanation for question #76. The question stem and answer options stay visible for context.
Replication
Question
You have configured GTID-based asynchronous replication with one master and one slave. A user accidentally updated some data on the slave. To fix this, you stopped replication and successfully reverted the accidental changes. Examine the current GTID information: You must fix GTID sets on the slave to avoid replicating unwanted transactions in case of failover. Which set of actions would allow the slave to continue replicating without erroneous transactions?
Exhibit
Options
- ARESET MASTER;
- BSET GLOBAL gtid_purged=aaaaaaaa-aaaa-aaaa-aaaa-aaaaaaaaaaaa:1-2312,bbbbbbbb-bbbb-
- CRESET SLAVE;
- DRESET MASTER;
- ERESET SLAVE;
Unlock 1Z0-908 to see the answer
You've previewed enough free 1Z0-908 questions. Unlock 1Z0-908 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.
Topics
#GTID replication#RESET MASTER#failover scenarios#transaction consistency