OCP Performance Tuning And Diagnostics Practice Question
The Automatic SQL Plan Management (ASPM) feature is enabled. A new execution plan is identified for a high-load query that performs better during testing. How does the database verify this plan before evolving the baseline?
Answer choices
Why each option matters
Answer the question above first, then reveal the full breakdown to understand why each option is right or wrong.
Correct answer & explanation
✓
It executes the SQL statement using the new plan and compares its performance metrics against the current baseline.
The database performs a verification task where it executes the new plan and compares it against the baseline performance to decide if it should be accepted.
Answer analysis
Option-by-option breakdown
For each option: why learners choose it and why it is or isn't the right answer here.
- ✗
It flags the plan for manual DBA approval via the DBMS_SPM package.
Why it's wrong here
While manual evolution is possible, the database can automate the verification process.
- ✗
It automatically promotes the plan based on the optimizer cost estimation.
Why it's wrong here
Promotion requires verification of actual performance, not just cost estimates.
- ✓
It executes the SQL statement using the new plan and compares its performance metrics against the current baseline.
Why this is correct
The database performs a trial execution to confirm performance improvement before evolving the plan baseline.
- ✗
It relies on the Advisor to run a full analysis of the explain plan tree.
Why it's wrong here
Explain plans do not capture runtime performance characteristics.
About these practice questions
This OCP question is part of Courseiva's 314-question bank — original exam-style content with full explanations and wrong-answer analysis, never real exam questions or exam dumps. Learn why practice questions differ from exam dumps →
JA
Written and reviewed by Johnson Ajibi, MSc IT Security
Senior Network & Security Engineer · founder of Courseiva
Last reviewed August 2026 · checked against the official Oracle exam blueprint
This OCP practice question is part of Courseiva's free Oracle certification practice question bank. Courseiva provides original exam-style practice questions with explanations, topic-based practice, mock exams, readiness tracking, and study analytics to help learners prepare for the OCP exam.