Free 1Z0-117 Web TestEngine Demo

Q17 Single choice

View the exhibit and examine the plans in the SQL baseline for a given statement.

Which interpretation is correct?

A
A new plan cannot be evolved because SYS_SQL_bbedc41f554c408 is accepted.
B
Plan SYS_SQL_PLAN_bbdc741f554c408 will always be used by the optimizer for the query.
C
A new plan must be evolved using the DBMS_SPM.EVOLVE_SQL_PLAN_BASELINE function before it can be used.
D
Plan SYS_SQL_bbedc741a57b5fc2 can be used by the optimizer if the cost of the query is less than plan SYS_SQL_PLAN_bbedc741f554c408.
E
Plan SYS_SQL_PLAN_bbedc741f554c408 will not be used until it is fixed by using the DBMS_SPM.EVOLVE_SQL_PLAN_BASELINE function.

1Z0-117 Web TestEngine demo