Oracle Database 12c: Installation and Administration — Question 71

Which three features work together, to allow a SQL statement to have different cursors for the same statement based on different selectivity ranges? (Choose three.)

Answer options

• A. Bind Variable Peeking
• B. SQL Plan Baselines
• C. Adaptive Cursor Sharing
• D. Bind variable used in a SQL statement
• E. Literals in a SQL statement

Correct answer: A, C, D

Explanation

The correct features are Bind Variable Peeking, Adaptive Cursor Sharing, and Bind variable used in a SQL statement. Bind Variable Peeking allows the optimizer to make better decisions based on the actual bind values, while Adaptive Cursor Sharing creates multiple execution plans based on different bind values. The option SQL Plan Baselines and Literals do not contribute to having different cursors based on selectivity ranges.