Oracle
1Z0-054 · Question #63
1Z0-054 Question #63: Real Exam Question with Answer & Explanation
Sign in or unlock 1Z0-054 to reveal the answer and full explanation for question #63. 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 the distribution of values in the table and the histograms on the table. View the Exhibits named QUERY-1 and QUERY-2 that show details in the V$SQL view for the queries executed on the SALES table. You check the plan table and notice that both the queries that executed on the SALES table used index range scan. The second query retrieved most of the rows in the table but used index range scan. Why would the second query use the same plan?
Exhibits
Options
- Abecause the plan was bind aware
- Bbecause the bind peeking never happened
- Cbecause the OPEN_CURSORS parameter is set to a very low value
- Dbecause the optimizer did not consider selectivity due to the use of bind variables
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.