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

ACE

ACE

Based on the Relo’s points and the documentation,

In order to have different cursors for the same statement, it should be AC and E.

If we use bindvariables, the same cursor will be used, if we use literals instead, the cursor will be changed for each literal.

A bind variable is a placeholder in a SQL statement that must be replaced with a valid value or value address for the statement to execute successfully. By using bind variables, you can write a SQL statement that accepts inputs or parameters at run time. The following query uses v_empid as a bind variable:
SELECT * FROM employees WHERE employee_id = :v_empid;
When a query uses literals, the optimizer can use the literal values to find the best plan. However, when a query uses bind variables, the optimizer must select the best plan without the presence of literals in the SQL text. This task can be extremely difficult. By peeking at bind values, the optimizer can determine the selectivity of a WHERE clause condition as if literals had been used, thereby improving the plan.
Use bind variables rather than literals in SQL statements whenever possible.
For example, the following statements cannot use the same shared area because they do not match character for character:
SELECT employee_id FROM employees WHERE department_id = 10;
SELECT employee_id FROM employees WHERE department_id = 20;
By replacing the literals with a bind variable, only one SQL statement would result, which could be executed twice:
SELECT employee_id FROM employees WHERE department_id = :dept_id;

In SQL parsing, an identical statement is a statement whose text is identical to another, character for character, including spaces, case, and comments. A similar statement is identical except for the values of some literals.
When SQL statements use literals rather than bind variables, a nondefault setting for the CURSOR_SHARING initialization parameter enables the database to replace literals with system-generated bind variables. Using this technique, the database can sometimes reduce the number of parent cursors in the shared SQL area.
So the correct answers are:
A,C,D

Since Default CURSOR_SHARING is EXACT, i would assume that when you use litererals (D), it doesn’t generate or look for different cursor. So I would go with “D” since whatever the CURSOR_SHARING is set – this looks for different cursor and plans.

ACD .

ACD

E is wrong because Adaptive cursor sharing does not apply to statements that contain only literals.

…Which three features work together…

Adaptive cursor sharing (C) can generate different plans based on value of bind variable. To use this feature, SQL statement has to have bind variables(D) and Oracle has to read value of bind variable(A).

so ACD features works _together_

may be B
https://blogs.oracle.com/optimizer/entry/how_do_adaptive_cursor_sharing

A wrong: In bind variable peeking (also known as bind peeking-sbirciare), the optimizer looks at the value in a bind variable only when the database performs a hard parse of a statement (does not look at the bind variable values in every parse) Optimizer peeks bind only when the optimizer is first invoked (which is during the hard parse).
B right: Since both plans are accepted in SQL Plan Baselines, both are eligible for execution which could be helpful in situations where a adaptive cursor sharing kicks in and the full scan would actually be the better plan.
C right: The adaptive cursor sharing feature enables a single statement that contains bind variables to use multiple execution plans. Cursor sharing is “adaptive” because the cursor adapts its behavior so that the database does not always use the same plan for each execution or bind variable value.
D wrong: with bind variable the execution plan is olways the same
E right: with literals values in “where” condition, the query every time take an different execution plan

B, C, E..
Right??

P.S. Free 1Z0-060 PDF dumps from Google Drive: https://drive.google.com/open?id=0B-ob6L_QjGLpNjQta2dQSmFJLWs