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

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

Contribute your Thoughts:

Submit Cancel

Inocencia

16 days ago

I'm gonna have to go with C and D. Although, I have to admit, option E sounds like something straight out of a comedy sketch. Imagine logging the duration and locks for every single query? Talk about information overload!

upvoted 0 times

...

Ettie

19 days ago

This is a no-brainer! C and D, all the way. Recovering from mistakes and setting up replication - that's the power of binary logs, baby!

upvoted 0 times

Daniel

4 days ago

C) point-in-time recovery

upvoted 0 times

...

An

5 days ago

A) recording the order in which queries are issued

upvoted 0 times

...

Krystal

21 days ago

Hmm, I'd go with C and D. Binary logs are like the flight recorders of the MySQL world, keeping track of everything for when things go wrong.

upvoted 0 times

...

Domonique

24 days ago

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

upvoted 0 times

...

Belen

25 days ago

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

upvoted 0 times

...

Stanford

26 days ago

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

upvoted 0 times

...

Carey

1 months ago

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

upvoted 0 times

...

Mari

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

Refugia

9 hours ago

I think A could also be useful for recording the order of queries.

upvoted 0 times

...

Sabra

15 days ago

I agree, C and D are essential for point-in-time recovery and replication.

upvoted 0 times

...

Lizette

1 months ago

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

upvoted 0 times

...