Oracle Exam 1Z0-064 Topic 11 Question 13 Discussion

Actual exam question for Oracle's 1Z0-064 exam

Question #: 13
Topic #: 11

In your database, supporting an OLTP workload, the SALES table is range-partitioned on the SALES_DATE column. A new partition is created every quarter and is frequently used for updates and queries. You recently noticed degraded performance of queries on a new partition due to stale statistics. A local partitioned index exists on the SALES_DATE column.

What would you recommend to improve performance?

Adropping the local partitioned index and creating a global partitioned index on the SALES_DATE column

Bsetting the INCREMENTAL preference to TRUE and the NO_INVALIDATE preference to TRUE for the partitioned table while gathering statistics

Csetting the INCREMENTAL preference to TRUE and the CASCADE preference to FALSE for the partitioned table while gathering statistics

Dsetting the INCREMENTAL preference to TRUE and the GRANULARITY preference to AUTO for the partitioned table while gathering statistics

Show Suggested Answer

Suggested Answer: D

by Nickolas at May 09, 2022, 07:51 AM

Limited Time Offer

25%

Off

Get Premium 1Z0-064 Questions as Interactive Web-Based Practice Test or PDF

Contribute your Thoughts:

Submit Cancel

Currently there are no comments in this discussion, be the first to comment!