Oracle
1Z0-117 · Question #13
1Z0-117 Question #13: Real Exam Question with Answer & Explanation
Sign in or unlock 1Z0-117 to reveal the answer and full explanation for question #13. The question stem and answer options stay visible for context.
Question
Examine the initializing parameters: An index exists on the column used in the WHERE of a query. You execute the query for the first time today and notice that the query is not using the index. The CUSTOMERS table has 55000 rows. View the exhibit and examine the query and its execution plan. What can be the two reasons for full table scan?
Exhibits
Options
- AThe value of the OPTIMIZER_INDEX_COST_ADJ parameter is set to a low value.
- BThe blocks fetched by the query are greater than the value specified by the DB_FILE_MULTIBLOCK_
- CThe statistics for the CUSTOMERS table and the indexes stale.
- DThe OPTIMIZER_MODE parameter is set to ALL_ROWS.
- EHistogram statistics for CUST_CITY_ID are missing.
- FAverage number of rows per block for the CUSTOMERS table is low.
Unlock 1Z0-117 to see the answer
You've previewed enough free 1Z0-117 questions. Unlock 1Z0-117 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.