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

Gaston

1 months ago

Seconds_behind_master? More like seconds behind my sanity after staring at this question for too long. *sips coffee dramatically*

upvoted 0 times

Otis

8 days ago

A) It 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.

upvoted 0 times

...

2 months 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

Veronique

1 months ago

User1: Oh, I see. Thanks for clarifying.

upvoted 0 times

...

Jacob

2 months ago

User3: I'm pretty sure it's C too.

upvoted 0 times

...

Rhea

2 months ago

User2: Actually, I believe it's A.

upvoted 0 times

...

Crista

2 months ago

User1: I think it's C.

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

26 days ago

Actually, I think it's option B. The time between the most recent transaction written to the relay logs and the time it was committed on the master.

upvoted 0 times

...

Julio

1 months ago

I'm not sure, but I think it might be option C. 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.

upvoted 0 times

...

Avery

2 months ago

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

upvoted 0 times

...

3 months ago

I think the answer is A.

upvoted 0 times

...

Oracle Exam 1Z0-908 Topic 5 Question 85 Discussion

Contribute your Thoughts:

Gaston

Otis

Hershel

Ivan

Miss

Jose

Millie

Fatima

Veronique

Jacob

Rhea

Crista

Carry

Avery

Julio

Avery

Valentine

Tonette

Heike

Tonette