READ Free Dumps For Oracle- 1z0-062

Question ID 2451	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?
Option A	A.    Using a partial local Index on the warehouse fact table month column with indexing disabled to the table partitions that return most of their rows to the queries.
Option B	B.    Using a partial local Index on the warehouse fact table month column with indexing disabled for the table partitions that return a few rows to the queries.
Option C	C.    Using a partitioned view that does a UNION ALL query on the partitions of the warehouse fact table, which retains the existing local partitioned column.
Option D	D.    Converting the partitioned table to a partitioned view that does a UNION ALL query on the monthly tables, which retains the existing local partitioned column.
Option E	E.    Using a partial global index on the warehouse fact table month column with indexing disabling for the table partitions that return most of their rows to the queries.
Option F	F.    Using a partial global index on the warehouse fact table month column with indexing disabled for the table partitions that return a few rows to the queries.
Correct Answer	B,C,E

Explanation

Question ID 2452	You use the segment advisor to help determine objects for which space may be reclaimed. Which three statements are true about the advisor given by the segment advisor?
Option A	A.    It may advise the use of online table redefinition for tables in dictionary managed tablespace.
Option B	B.    It may advise the use of segment shrink for tables in dictionary managed tablespaces it the no chained rows.
Option C	C.    It may advise the use of online table redefinition for tables in locally managed tablespaces
Option D	D.    It will detect and advise about chained rows.
Option E	E.    It may advise the use of segment shrink for free list managed tables.
Correct Answer	B,C,E

Explanation

Previous-Page 1 2. . . 57 58 59 60 61 62 63. . . 103 104 Next-Page

Send email to admin@getfreedumps for new dumps request!!!