Oracle Database Administration 2022 Certified Professional — Question 19

You use SQL Tuning Advisor to tune a given SQL statement.
The analysis eventually results in the implementation of a SQL Profile.
You then generate the new SQL Profile plan and enforce it using a SQL Plan Baseline but forget to disable the SQL Profile and a few days later you find out that the SQL Profile is generating a new execution plan.
Which two statements are true? (Choose two.)

Answer options

• A. The SQL Profiles as well as SQL Plan Baseline are implemented using hints, so they both generate the same plan.
• B. The execution plan is the one enforced by the SQL Profile.
• C. The execution plan is the one enforced by the SQL Plan Baseline.
• D. The SQL Plan Baseline must be accepted in order to be used for the execution plan.
• E. The conflict between the two plan stability methods results in an error.
• F. The existence of two concurrent plan stability methods generates a child cursor for every execution.

Correct answer: B, D

Explanation

The correct answer B is accurate because when a SQL Profile is active, it can override the execution plan enforced by the SQL Plan Baseline. Answer D is also correct, as the SQL Plan Baseline must be accepted to be utilized in the execution plan. The other options are incorrect because they misrepresent how SQL Profiles and SQL Plan Baselines function and interact with each other.