Oracle Exam 1Z0-064 Topic 2 Question 36 Discussion

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

Question #: 36
Topic #: 2

In the CUSTOMERS table, the values in the CUST_STATE column are dependent on the values in the COUNTRY_ID column. You want to make the optimizer aware of this dependency when these columns are used together in WHERE clause predicates that contain equalities or in-lists.

Which two methods achieve this? (Choose two.)

Agathering statistics on the CUSTOMERS table and its dependent objects, and then locking the statistics

Busing SQL plan directives to generate an optimal plan

Csetting the dynamic statistics level to 4 and setting the OPTIMIZER_USE_PENDING_STATISTICS initialization parameter to true

Dcreating column group statistics, regathering statistics, and ensuring that histograms exist on both these columns

Show Suggested Answer

Suggested Answer: A, D

by Mona at May 03, 2022, 06:45 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!