Oracle
1Z0-117 · Question #9
1Z0-117 Question #9: Real Exam Question with Answer & Explanation
Sign in or unlock 1Z0-117 to reveal the answer and full explanation for question #9. The question stem and answer options stay visible for context.
Question
You are administering a database supporting an OLTP application. The application runs a series of extremely similar queries the MYSALES table where the value of CUST_ID changes. Examine Exhibit1 to view the query and its execution plan. Examine Exhibit 2 to view the structure and indexes for the MYSALES table. The MYSALES table has 4 million records. Data in the CUST_ID column is highly skewed. Examine the parameters set for the instance: Which action would you like to make the query use the best plan for the selectivity?
Exhibits
Options
- ADecrease the value of the OPTIMIZER_DYNAMIC_SAMPLING parameter to 0.
- BUs the /*+ INDEX(CUST_ID_IDX) */ hint in the query.
- CDrop the existing B* -tree index and re-create it as a bitmapped index on the CUST_ID column.
- DCollect histogram statistics for the CUST_ID column and use a bind variable instead of literal values.
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.