Oracle
1Z0-117 · Question #105
1Z0-117 Question #105: Real Exam Question with Answer & Explanation
Sign in or unlock 1Z0-117 to reveal the answer and full explanation for question #105. The question stem and answer options stay visible for context.
Question
In Your Database, The Cursor_Shareing Parameter is set to EXACT. In the Employees table, the data is significantly skewed in the DEPTNO column. The value 10 is found in 97% of rows. Examine the following command and out put. Which three statements are correct?
Exhibit
Options
- AThe DEPTNO column will become bind aware once histogram statistics are collected.
- BThe value for the bind variable will considered by the optimizer to determine the execution plan.
- CThe same execution plan will always be used irrespective of the bind variable value.
- DThe instance collects statistics and based on the pattern of executions creates a histogram on the column
- EBind peeking will take place only for the first execution of the statement and subsequent execution will
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.