Oracle
1Z0-054 · Question #204
1Z0-054 Question #204: Real Exam Question with Answer & Explanation
Sign in or unlock 1Z0-054 to reveal the answer and full explanation for question #204. The question stem and answer options stay visible for context.
Question
You are working on a decision support system (DSS). The index is available on the COUNTRY_ID column of the CUSTOMERS table. View the Exhibit and examine the parameter settings and the query execution plan. Why is the query using a full table scan instead of an index scan?
Exhibit
Options
- Abecause the histogram statistics for the COUNTRY_ID column are not updated
- Bbecause the index statistics for the index on the COUNTRY_ID column are not current
- Cbecause the DB_FILE_MULTIBLOCK_READ_COUNT initialization parameter is set to a higher
- Dbecause the optimizer predicts that most of the blocks in the table are accessed.
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.