Oracle Exam 1Z0-064 Topic 4 Question 17 Discussion

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

Question #: 17
Topic #: 4

The SALES table has over one million rows. Statistics for the SALES table and its dependent objects are gathered by the Oracle AutoTask task during a predefined maintenance window.

Examine the query:

Which two actions can improve the accuracy of cardinality estimates for this query?

Aensuring that histograms exist for the CUST_ID and PROD_ID columns

Bsetting the OPTOMIZER_DYNAMIC_SAMPLING parameter to 4 to augment the default standard statistics

Csetting the FORCE parameter of the GATHER_*_STATS procedure to TRUE and gathering statistics for the SALES table and its dependent objects

Dgathering system statistics during peak workload time to augment the standard statistics

Show Suggested Answer

Suggested Answer: A, D

by Margart at May 09, 2022, 09:20 PM

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!