Oracle
1Z0-054 · Question #27
Which three statements are true about performance analysis by SQL Performance Analyzer? (Choose three.)
The correct answer is A. It detects changes in SQL execution plans. C. It produces results that can be used to create the SQL plan baseline. D. It generates recommendations to run SQL Tuning Advisor to tune regressed SQL statements. See the full explanation below for the reasoning.
Question
Which three statements are true about performance analysis by SQL Performance Analyzer? (Choose three.)
Options
- AIt detects changes in SQL execution plans.
- BIt shows only the overall impact on workload.
- CIt produces results that can be used to create the SQL plan baseline.
- DIt generates recommendations to run SQL Tuning Advisor to tune regressed SQL statements.
- EThe importance of SQL statements to be analyzed is based on the size of the objects accessed.
How the community answered
(34 responses)- A74% (25)
- B18% (6)
- E9% (3)
Community Discussion
No community discussion yet for this question.