Oracle
1Z0-064 · Question #65
1Z0-064 Question #65: Real Exam Question with Answer & Explanation
Sign in or unlock 1Z0-064 to reveal the answer and full explanation for question #65. The question stem and answer options stay visible for context.
Question
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.)
Options
- Agathering statistics on the CUSTOMERS table and its dependent objects, and then locking the
- Busing SQL plan directives to generate an optimal plan
- Csetting the dynamic statistics level to 4 and setting the
- Dcreating column group statistics, regathering statistics, and ensuring that histograms exist on both
Unlock 1Z0-064 to see the answer
You've previewed enough free 1Z0-064 questions. Unlock 1Z0-064 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.