Oracle Exam 1Z0-908 Topic 11 Question 80 Discussion

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

Question #: 80
Topic #: 11

[All 1Z0-908 Questions]

Your MySQL environment has asynchronous position based-replication with one master and one slave.

The slave instance had a disk I/O problem, so it was stopped.

You determined that the slave relay log files were corrupted and unusable, but no other files are damaged.

You restart MySQL Server.

How can replication be restored?

AThe slave relay logs should be deleted; then execute START SLAVE;

BThe relay logs from the master should be used to replace the corrupted relay logs.

CThe slave relay logs should be deleted; execute CHANGE MASTER to adjust the replication relay log file name, then issue start SLAVE;

DThe slave needs to be restored from backup.

Show Suggested Answer

Suggested Answer: B

by Annita at May 29, 2024, 03:45 AM

Limited Time Offer

25%

Off

Get Premium 1Z0-908 Questions as Interactive Web-Based Practice Test or PDF

Contribute your Thoughts:

Submit Cancel

Lashonda

6 months ago

Ah, the joys of database administration. Option C is the way to go, for sure. Gotta love it when the solution is as simple as deleting and re-configuring.

upvoted 0 times

...

Gilberto

6 months ago

Heh, the slave had a 'disk I/O problem,' huh? Sounds like someone's been sneaking their coffee into the server room again. But in all seriousness, C is the clear winner here.

upvoted 0 times

Brittni

5 months ago

C) The slave relay logs should be deleted; execute CHANGE MASTER to adjust the replication relay log file name, then issue start SLAVE;

upvoted 0 times

...

Nenita

5 months ago

B) The relay logs from the master should be used to replace the corrupted relay logs.

upvoted 0 times

...

Jestine

5 months ago

A) The slave relay logs should be deleted; then execute START SLAVE;

upvoted 0 times

...

Nicholle

6 months ago

I'm not sure, but option B seems a bit risky. Using the master's relay logs to replace the corrupted ones? Sounds like a recipe for disaster. Maybe it's best to just start fresh with option C.

upvoted 0 times

...

Shaun

6 months ago

I disagree, I believe the correct answer is C) The slave relay logs should be deleted; execute CHANGE MASTER to adjust the replication relay log file name, then issue start SLAVE.

upvoted 0 times

...

Vilma

6 months ago

Hmm, I think option C is the way to go. Deleting the corrupted relay logs and adjusting the replication settings sounds like the most straightforward approach.

upvoted 0 times