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

Oracle MySQL 8.0 Database Administrator 1z0-908 Question # 8 Topic 1 Discussion

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

Oracle MySQL 8.0 Database Administrator 1z0-908 Question # 8 Topic 1 Discussion

1z0-908 Exam Topic 1 Question 8 Discussion:
Question #: 8
Topic #: 1

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:

1z0-908 Question 8

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?
A.

RESET MASTER;

SET GLOBAL gtid_purged=aaaaaaaa-aaaa-aaaa-aaaa-aaaaaaaaaaaa:1-10167;

B.

SET GLOBAL gtid_purged=aaaaaaaa-aaaa-aaaa-aaaa-aaaaaaaaaaaa:1-2312,bbbbbbbb- bbbb-bbbb-bbbb-bbbbbbbbbbbb:1-9;

SET GLOBAL gtid_executed=aaaaaaaa-aaaa-aaaa-aaaa-aaaaaaaaaaaa:1-10167;

C.

RESET SLAVE;

SET GLOBAL gtid_purged=aaaaaaaa-aaaa-aaaa-aaaa-aaaaaaaaaaaa:1-3820;

SET GLOBAL gtid_executed=aaaaaaaa-aaaa-aaaa-aaaa—aaaaaaaaaaaa:1-10300;

D.

RESET MASTER;

SET GLOBAL gtid_purged-aaaaaaaa-aaaa-aaaa-aaaa-aaaaaaaaaaaa:1-2312;

SET GLOBAL gtid_executed=aaaaaaaa-aaaa-aaaa-aaaa-aaaaaaaaaaaa:1-10167;

E.

RESET SLAVE;

SET GLOBAL gtid_purged=aaaaaaaa-aaaa-aaaa-aaaa-aaaaaaaaaaaa:1-10167;

Get Premium 1z0-908 Questions
Actual exam question for Oracle 1z0-908 exam by Zane3898 at Aug 2, 2025, 12:00:00 AM

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