Oracle
1Z0-054 · Question #20
1Z0-054 Question #20: Real Exam Question with Answer & Explanation
Sign in or unlock 1Z0-054 to reveal the answer and full explanation for question #20. The question stem and answer options stay visible for context.
Question
The columns CUST_CITY, CUST_STATE_PROVINCE, and COUNTRY_ID are frequently used together in the WHERE clause of the queries. The CUSTOMERS table is a big table with 20 GB of data. You notice that the selectivity for these three columns varies from the selectivity that the optimizer calculates. What would you recommend to influence the selectivity calculated by the optimizer?
Options
- Acreating function-based indexes by concatenating all the columns
- Bupdating histogram statistics for these columns by using the
- Cusing the DBMS_STATS.CREATE_EXTENDED_STATS function to create a virtual column and
- Dusing the DBMS_STATS.CREATE_EXTENDED_STATS function to create a virtual column and
Unlock 1Z0-054 to see the answer
You've previewed enough free 1Z0-054 questions. Unlock 1Z0-054 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.