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

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

Avery

1 months ago

Yeah, option E does seem a bit excessive. It would be too much information to handle.

upvoted 0 times

...

Jani

1 months ago

I agree, C and D are the most practical uses for binary logs.

upvoted 0 times

...

Ettie

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

Enola

27 days ago

Setting up replication with binary logs is a game-changer for database scalability.

upvoted 0 times

...

Marci

1 months ago

Binary logs are a lifesaver when it comes to recovering from errors.

upvoted 0 times

...

Albert

1 months ago

Point-in-time recovery and replication are essential for database management.

upvoted 0 times

...

Christiane

1 months ago

I agree, C and D are definitely the way to go.

upvoted 0 times

...

Jaclyn

1 months ago

D) replication

upvoted 0 times

...

Daniel

2 months ago

C) point-in-time recovery

upvoted 0 times

...

An

2 months ago

A) recording the order in which queries are issued

upvoted 0 times

...

Krystal

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

2 months ago

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

upvoted 0 times

...

Belen

3 months ago

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

upvoted 0 times

...

Stanford

3 months ago

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

upvoted 0 times

...

Carey

3 months ago

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

upvoted 0 times

...

Mari

3 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

Ryan

1 months ago

True, but E seems like it could provide valuable information on query performance.

upvoted 0 times

...

Refugia

2 months ago

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

upvoted 0 times

...

Sabra

2 months ago

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

upvoted 0 times

...

Lizette

3 months ago

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

upvoted 0 times

...