Oracle Exam 1Z0-908 Topic 5 Question 85 Discussion

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

Question #: 85
Topic #: 5

You issue this command:

SHOW SLAVE STATUS -

In the output, there is a value for Seconds_behind_master.

How is this time calculated?

AIt is the time between the I/O thread receiving details of the master's last transaction and the time it was applied by the SQL thread.

BIt is the time between the most recent transaction written to the relay logs and the time it was committed on the master.

CIt is the time between the I/O thread receiving details of the master's last transaction and the time it was written to the relay log on the slave.

DIt is the time between the most recent transaction applied by a SQL thread and the time it was committed on the master.

Show Suggested Answer

Suggested Answer: A, D, E

by Margo at Aug 03, 2024, 02:11 PM

Limited Time Offer

25%

Off

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

Contribute your Thoughts:

Submit Cancel

Millie

3 days ago

D sounds plausible, but I'm pretty sure that's not how Seconds_behind_master is calculated. Time to hit the books again!

upvoted 0 times

...

Fatima

8 days ago

Hmm, I'm not sure about this one. I was thinking it might be C, but now I'm second-guessing myself. Guess I need to review my MySQL replication concepts before the exam.

upvoted 0 times

...

I think the correct answer is A. The Seconds_behind_master value represents the time between the I/O thread receiving the master's transaction details and when the SQL thread applies it on the slave. That makes the most sense to me.

upvoted 0 times

Avery

7 days ago

I agree with you. It does seem like the logical calculation for the Seconds_behind_master value.

upvoted 0 times

...

Valentine

8 days ago

upvoted 0 times

...

Tonette

21 days ago

But A makes more sense because it's about the time between receiving details and applying them.

upvoted 0 times

...

Heike

22 days ago

I disagree, I believe the correct answer is C.

upvoted 0 times

...

Tonette

28 days ago

I think the answer is A.

upvoted 0 times

...

Oracle Exam 1Z0-908 Topic 5 Question 85 Discussion

Contribute your Thoughts:

Millie

Fatima

Carry

Avery

Valentine

Tonette

Heike

Tonette