Oracle
1Z0-117 · Question #80
1Z0-117 Question #80: Real Exam Question with Answer & Explanation
Sign in or unlock 1Z0-117 to reveal the answer and full explanation for question #80. The question stem and answer options stay visible for context.
Question
Identify two situations in which full table scans will be faster than index range scans.
Options
- AA query with a highly selective filter fetching less than 5 percent of the rows from a table.
- BA highly selective query on a table having high clustering factor for an index.
- CA query fetching less number of blocks than value specified by DB_FILE_MULTIBLOCK_READ_COUNT.
- DA query executing in parallel on a partitioned table with partitioned indexes.
- EA query on a table with sparsely populated table blocks.
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.