Oracle Exam 1Z0-909 Topic 9 Question 61 Discussion

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

Question #: 61
Topic #: 9

[All 1Z0-909 Questions]

Examine these my.cnf settings:

Examine this entry from /data/slow.log

Which option is also set in my.cnf?

Alog_queries_not_using_indexes

Blog__slow_admin_statements=1

Clog_queries_not_using_indexes=ON

Dlog_throttle_queries_not_using_indexes=100

Show Suggested Answer

Suggested Answer: B

by Lonny at Apr 30, 2025, 09:45 AM

Limited Time Offer

25%

Off

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

Contribute your Thoughts:

Submit Cancel

Robt

20 hours ago

Haha, this question is a real head-scratcher! I'm going to go with B) log__slow_admin_statements=1. It's got two underscores, so it must be the right answer, right? That's how these things work, right?

upvoted 0 times

...

Chaya

4 days ago

Wow, this question is a real brain-teaser! I bet the answer is D) log_throttle_queries_not_using_indexes=100. Why? Because it sounds the most complex and technical, and that's exactly the kind of answer they love to throw at us.

upvoted 0 times

...

Marva

9 days ago

Hmm, based on the information provided, I think the correct answer is C) log_queries_not_using_indexes=ON. The slow.log entry clearly shows that this option is enabled.

upvoted 0 times

...