Oracle
1Z0-050 · Question #75
You run the SQL Tuning Advisor (STA) to tune a SQL statement that is part of a fixed SQL plan baseline. The STA generates a SQL profile for the SQL statement, which recommends that you accept the…
The correct answer is C. The tuned plan is added to the fixed SQL plan baseline as a nonfixed plan. See the full explanation below for the reasoning.
Question
You run the SQL Tuning Advisor (STA) to tune a SQL statement that is part of a fixed SQL plan baseline. The STA generates a SQL profile for the SQL statement, which recommends that you accept the profile. Which statement is true when you accept the suggested SQL profile?
Options
- AThe tuned plan is not added to the SQL plan baseline.
- BThe tuned plan is added to the fixed SQL plan baseline as a fixed plan.
- CThe tuned plan is added to the fixed SQL plan baseline as a nonfixed plan.
- DThe tuned plan is added to a new nonfixed SQL plan baseline as a nonfixed plan.
How the community answered
(18 responses)- A11% (2)
- C72% (13)
- D17% (3)
Community Discussion
No community discussion yet for this question.