Oracle Exam 1Z0-888 Topic 13 Question 2 Discussion

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

Question #: 2
Topic #: 13

You have a MySQL replication setup and you intentionally stop the SQL thread on the slave.

What are two reasons that you may stop the SQL thread on the slave while keeping the I/O thread running? (Choose two.)

Ato allow the remaining events to be processed on the slave while not receiving new events from the master

Bto allow a backup to be created under reduced load

Cto allow for point-in-time recovery on the slave

Dto prevent schema changes from propagating to the slave before they are validated

Eto prevent any transaction experiencing a deadlock

Show Suggested Answer

Suggested Answer: B, C

by Junita at May 09, 2022, 05:20 AM

Limited Time Offer

25%

Off

Contribute your Thoughts:

Submit Cancel

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