【单选题】The Database Resource Manager is not currently active in your database that is up and running. You created a resource plan named DAY_PLAN that contains two sub-plans named MANAGERS_PLAN and CLERKS_PLA...
A.
The statement will deactivate DAY_PLAN.
B.
The statement will activate DAY_PLAN as the top plan.
C.
The statement will activate MANAGERS_PLAN as the top plan.
D.
The statement will return an error because MANAGERS_PLAN is not the top plan.
【多选题】The OPTIMIZER_USE_PLAN_BASELINES parameter is set to TRUE. The optimizer generates a plan for a SQL statement but does not find a matching plan in the SQL plan baseline. Which two operations are perfo...
A.
The optimizer adds the new plan to the plan history.
B.
The optimizer selects the new plan for the execution of the SQL statement.
C.
The optimizer adds the new plan to the SQL plan baseline as an accepted plan.
D.
The optimizer adds the new plan to the SQL plan baseline but not in the ENABLED state.
E.
The optimizer costs each of the accepted plans in the SQL plan baseline and picks the one with the lowest cost.