Oracle
1Z0-117 · Question #118
1Z0-117 Question #118: Real Exam Question with Answer & Explanation
Sign in or unlock 1Z0-117 to reveal the answer and full explanation for question #118. The question stem and answer options stay visible for context.
Question
View the Exhibit1 and examine the structure and indexes for the MYSALES table. The application uses the MYSALES table to insert sales record. But this table is also extensively used for generating sales reports. The PROD_ID and CUST_ID columns are frequently used in the WHERE clause of the queries. These columns are frequently used in WHERE clause of the queries. These columns have few distinct values relative to the total number of rows in the table. View exhibit 2 and examine one of the queries and its auto trace output. What should you do to improve the performance of the query?
Exhibits
Options
- AUse the INDEX_COMBINE hint in the query.
- BCreate composite index involving the CUST_ID and PROD_ID columns.
- CGather histograms statistics for the CUST_ID and PROD_ID columns.
- DGather index statistics for the MYSALES_PRODID_IDX and MYSALES_CUSTID_IDX indexes.
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.