多做题,通过考试没问题!

Oracle认证考试

睦霖题库>其他计算机考试>Oracle认证考试

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 performed by the optimizer in this scenario?()

  • 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.
正确答案:A,E
答案解析:
进入题库查看解析

微信扫一扫手机做题