Oracle
1Z0-064 · Question #65
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…
The correct answer is A. gathering statistics on the CUSTOMERS table and its dependent objects, and then locking the D. creating column group statistics, regathering statistics, and ensuring that histograms exist on both. See the full explanation below for the reasoning.
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
How the community answered
(51 responses)- A80% (41)
- B14% (7)
- C6% (3)
Community Discussion
No community discussion yet for this question.