Oracle
1Z0-054 · Question #64
1Z0-054 Question #64: Real Exam Question with Answer & Explanation
Sign in or unlock 1Z0-054 to reveal the answer and full explanation for question #64. The question stem and answer options stay visible for context.
Question
You work on an online transaction processing (OLTP) database in which the SALES table has 10,000 rows but only four distinct products are sold. View the Exhibit named HIST to check data distribution in the table and the histograms on the table. View the Exhibit named QUERY-1 that shows details in the V$SQL view for the query executed on the SALES table having product id 1. Further, you query the SALES table thrice more in the following order: - query rows having product ID 4 - query rows having product ID 2 - query rows having product ID 4 View the Exhibit named QUERY-n to see the details about these queries. What do you infer from this?
Exhibit
Options
- AThe second plan was created because the first plan was aged out.
- BThe CURSOR_SHARING parameter value was changed to EXACT after the second query was
- CThe third plan was created because the first plan was aged out and the second plan had different
- DThe first two executions used the same plan because at parse time the optimizer did not consider
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.