Oracle
1Z0-117 · Question #119
1Z0-117 Question #119: Real Exam Question with Answer & Explanation
Sign in or unlock 1Z0-117 to reveal the answer and full explanation for question #119. The question stem and answer options stay visible for context.
Question
You are administering database that supports an OLTP workloads. Most of the queries use an index range scan or index unique scan as access methods. Which three scenarios can prevent the index access being used by the queries?
Options
- AWhen highly selective filters is applied on an indexed column of a table with sparsely populated blocks.
- BWhen the rows are filtered with an IS NULL operator on the column with a unique key defined
- CWhen the histogram statistics are not collected for the columns used in where clause.
- DWhen a highly selective filter is applied on the indexed column and the index has very low value for
- EWhen the statistics for the table are not current.
Unlock 1Z0-117 to see the answer
You've previewed enough free 1Z0-117 questions. Unlock 1Z0-117 for full answers, explanations, the timed quiz mode, progress tracking, and the master PDF. Question stem and options stay visible so you can still see what's on the exam.