ExamTopics Logo
Mail Us[email protected]
Menu
Oracle Discussions
exam questions

Exam 1z0-908 All Questions

View all questions & answers for the 1z0-908 exam
Go to Exam

Exam 1z0-908 topic 1 question 131 discussion

Actual exam question from Oracle's 1z0-908
Question #: 131
Topic #: 1
[All 1z0-908 Questions]

Your my.cnf file contains these settings:

You want to log queries that looked at a minimum of 5000 records and either took longer than 5 seconds to run or did not use indexes.
Which contains all the settings that you need to add to or modify the slow log configuration?

  • A. min_examined_row_limit=5000
  • B. long_query_time=5
    log_throttle_queries_not_using_indexes=5
  • C. log_throttle_queries_not_using_indexes=5
    min_examined_ row_limit=5000
  • D. long_query_time=5
  • E. long_query_time=5
    min_examined_row_limit=5000
  • F. log_throttle_queries_not_using_indexes=5
  • G. long_query_time=5
    log_throttle_queries_not_using_indexes=5
    min_examined_row_limit=5000
Show Suggested Answer Hide Answer
Suggested Answer: C 🗳️
by marklv at Sept. 6, 2023, 6:39 p.m.

Comments

Chosen Answer:
This is a voting comment (?). It is better to Upvote an existing comment if you don't have anything to add.
Switch to a voting comment New
Submit Cancel
marklv
4 months, 1 week ago
G is it
upvoted 1 times
marklv
2 months, 2 weeks ago
E sorry. log_queries_not_using_indexes only limits the number of queries that don't ue indexes to the log, to it has nothing to do with what we want.
upvoted 1 times
...
...
Community vote distribution
A (35%)
C (25%)
B (20%)
Other
Most Voted
A voting comment increases the vote count for the chosen answer by one.

Upvoting a comment with a selected answer will also increase the vote count towards that answer by one. So if you see a comment that you already agree with, you can upvote it instead of posting a new comment.

SaveCancel
exam
Someone Bought Contributor Access for:
SY0-701
London, 1 minute ago