Oracle
1Z0-054 · Question #202
1Z0-054 Question #202: Real Exam Question with Answer & Explanation
Sign in or unlock 1Z0-054 to reveal the answer and full explanation for question #202. The question stem and answer options stay visible for context.
Question
View Exhibit1 to examine the description of the CUSTOMERS table. You observed that optimizer selectivity is not accurate when the CUST_STATE_PROVINCE and COUNTRY_ID columns are used together in the WHERE clause of a query. View Exhibit2 to examine the query execution plan and the commands executed to gather the statistics. The optimizer predicts that 20 rows will be processed rather than the 3,341 rows, which is the actual number of rows returned from the table. What can you do to make the optimizer detect the actual number of rows?
Exhibits
Options
- ASet the STATISTICS_LEVEL parameter to ALL.
- BSet the OPTIMIZER_USE_PENDING_STATISTICS parameter to FALSE.
- CCreate extended statistics for the CUST_STATE_PROVINCE and COUNTRY_ID columns.
- DIncrease the STALE_PERCENT value 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.