Oracle
1Z0-034 · Question #152
Which three statements about performance analysis by SQL Performance Analyzer are true? (Choose three.)
The correct answer is A. It detects changes in SQL execution plans. B. 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 SQLs. See the full explanation below for the reasoning.
Question
Which three statements about performance analysis by SQL Performance Analyzer are true? (Choose three.)
Options
- AIt detects changes in SQL execution plans.
- BIt produces results that can be used to create the SQL plan baseline.
- CThe importance of SQL statements is based on the size of the objects accessed.
- DIt generates recommendations to run SQL Tuning Advisor to tune regressed SQLs.
- EIt shows only the overall impact on workload and not the net SQL impact on workload.
How the community answered
(29 responses)- A76% (22)
- C17% (5)
- E7% (2)
Community Discussion
No community discussion yet for this question.