Which three statements are true about adaptive SQL plan management?
A. It adds new; bettor plans automatically as fixed plans to the baseline.
B. The non-accepted plans are automatically accepted and become usable by the optimizer if they perform better than the existing accepted plans.
C. It automatically performs verification or evolves non-accepted plans, in COMPREHENSIVE mode when they perform better than existing accepted plans.
D. 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.
Correct Answer:
BCD