Oracle
1Z0-054 · Question #203
1Z0-054 Question #203: Real Exam Question with Answer & Explanation
Sign in or unlock 1Z0-054 to reveal the answer and full explanation for question #203. The question stem and answer options stay visible for context.
Question
View Exhibit1 to examine the description of the CUSTOMERS table. The CUSTOMERS table has been updated heavily today. In a frequently used SQL statement, you notice that estimated rows and the actual number of rows fetched differ greatly. The COUNTRY_ID column has an index. View Exhibit2 and examine the query execution plan. What would you recommend to improve the optimizer's estimation?
Exhibit
Options
- Asetting the STATISTICS_LEVEL parameter to ALL
- Bsetting the OPTIMIZER_USE_PENDING_STATISTICS parameter to FALSE
- Ccreating extended statistics for the CUST_LAST_NAME, CUST_ID, and CUST_TOTAL columns
- Dupdating the statistics for the CUSTOMERS table by using the
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.