Oracle
1Z0-062 · Question #101
1Z0-062 Question #101: Real Exam Question with Answer & Explanation
Sign in or unlock 1Z0-062 to reveal the answer and full explanation for question #101. The question stem and answer options stay visible for context.
Managing Performance
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
- DConverting the partitioned table to a partitioned view that does a UNION ALL query on the
- 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-062 to see the answer
You've previewed enough free 1Z0-062 questions. Unlock 1Z0-062 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.
Topics
#Partitioning#Indexes#Query optimization#Execution plans