Oracle Exam 1Z0-908 Topic 12 Question 100 Discussion

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

Question #: 100
Topic #: 12

[All 1Z0-908 Questions]

Which two are valid uses for binary logs on a MySQL instance? (Choose two.)

Arecording the order in which queries are issued

Baudit of all queries

Cpoint-in-time recovery

Dreplication

Elogging the duration and locks for all queries

Show Suggested Answer

Suggested Answer: A, C

by Chantell at Mar 20, 2025, 01:59 AM

Limited Time Offer

25%

Off

Contribute your Thoughts:

Submit Cancel

7 hours ago

D is definitely one, and I'd say C as well. Gotta love that point-in-time recovery feature!

upvoted 0 times

...

1 days ago

I think E is not a valid use, logging duration and locks is not typically done with binary logs.

upvoted 0 times

...

2 days ago

I believe A and B are also valid, recording query order and auditing queries.

upvoted 0 times

...

6 days ago

I agree with Lizette, point-in-time recovery and replication are important.

upvoted 0 times

...

6 days ago

C and D for sure! Binary logs are the way to go for point-in-time recovery and replication. A and E seem a bit overkill for my liking.

upvoted 0 times

...

9 days ago

I think C and D are valid uses for binary logs.

upvoted 0 times

...