Oracle
1Z0-117 · Question #114
1Z0-117 Question #114: Real Exam Question with Answer & Explanation
Sign in or unlock 1Z0-117 to reveal the answer and full explanation for question #114. The question stem and answer options stay visible for context.
Question
Examine the utilization parameters for an instance: You notice that despite having an index on the column used in the where clause, queries use full table scans with highly selective filters. What are two possible reasons for the optimizer to use full table scans instead of index unique scans and index range scans?
Exhibit
Options
- AThe OPTIMIZER_MODE parameter is set to ALL_ROWS.
- BThe clustering factor for the indexes is high.
- CThe number of leaf blocks for the indexes is high.
- DThe OPTIMIZER_INDEX_COST_ADJ initialization parameter is set to 100.
- EThe blocks fetched by the query are greater than the value specified by the DB_FILE_MULTIBLOCK_
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.