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

Oracle认证考试

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

Which three statements are true about adaptive SQL plan management?()

  • A、It automatically performs verification or evolves non-accepted plans, in COMPREHENSIVE mode when they perform better than existing accepted plans.
  • B、The optimizer always uses the fixed plan, if the fixed plan exists in the plan baseline.
  • C、It adds new, bettor plans automatically as fixed plans to the baseline.
  • D、The non-accepted plans are automatically accepted and become usable by the optimizer if they perform better than the existing accepted plans.
  • E、The non-accepted plans in a SQL plan baseline are automatically evolved, in COMPREHENSIVE mode, during the nightly maintenance window and a persistent verification report is generated.
正确答案:A,D,E
答案解析:
进入题库查看解析

微信扫一扫手机做题