Oracle
1Z0-060 · Question #108
1Z0-060 Question #108: Real Exam Question with Answer & Explanation
Sign in or unlock 1Z0-060 to reveal the answer and full explanation for question #108. The question stem and answer options stay visible for context.
Question
A warehouse fact table in your Oracle 12c Database is range-partitioned by month and accessed frequently with queries that span multiple partitions The table has a local prefixed, range partitioned index. Some of these queries access very few rows in some partitions and all the rows in other partitions, but these queries still perform a full scan for all accessed partitions. This commonly occurs when the range of dates begins at the end of a month or ends close to the start of a month. You want an execution plan to be generated that uses indexed access when only a few rows are accessed from a segment, while still allowing full scans for segments where many rows are returned. Which three methods could transparently help to achieve this result?
Options
- AUsing a partial local Index on the warehouse fact table month column with indexing disabled to
- BUsing a partial local Index on the warehouse fact table month column with indexing disabled for
- CUsing a partitioned view that does a UNION ALL query on the partitions of the warehouse fact table,
- DConverting the partitioned table to a partitioned view that does a UNION ALL query on the monthly
- EUsing a partial global index on the warehouse fact table month column with indexing disabling for
- FUsing a partial global index on the warehouse fact table month column with indexing disabled for
Unlock 1Z0-060 to see the answer
You've previewed enough free 1Z0-060 questions. Unlock 1Z0-060 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.