Oracle Database 12c: Installation and Administration — Question 121

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

Answer options

• 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

Correct answer: A, D, E

Explanation

The correct answers A, D, and E describe the functionalities of adaptive SQL plan management, focusing on how it evolves and accepts plans based on performance. Option B is incorrect because while a fixed plan can be used, it is not the only option considered by the optimizer. Option C is also incorrect as it misstates the automatic process of adding new plans to the baseline.