Oracle Database Administration II — Question 41

Which two are true about SQL Performance Analyzer (SPA)? (Choose two.)

Answer options

• A. It is integrated with the SQL Access Advisor.
• B. It predicts the impact of system changes on SQL workload response time.
• C. It provides before and after execution statistics for each SQL statement in the analysis task
• D. It offers fine-grained analysis of all the SQL statements in the analysis task as a group.
• E. SQL statements that were originally run concurrently are run concurrently by SPA.

Correct answer: B, C

Explanation

The correct answers are B and C because SPA is designed to predict how changes will affect SQL workload response times and provides execution statistics for each SQL statement before and after analysis. Options A, D, and E are incorrect as they either misrepresent SPA's features or functions that are not part of its capabilities.