Which three statements are true about the SQL Performance Analyzer? (Choose three.)

The correct answer is A. It recommends the use of SQL Tuning Advisor for regressed SQL statements. C. It compares and analyzes execution plans for the SQL statements in a SQL Tuning Set (STS). E. It generates execution plans for each SQL statement in an STS. Explanation/Reference: https://docs.oracle.com/cd/B19306_01/server.102/e12024/spa.htm

New Features for Performance

Question

Options

AIt recommends the use of SQL Tuning Advisor for regressed SQL statements.
BIt recommends the creation of indexes for regressed SQL statements.
CIt compares and analyzes execution plans for the SQL statements in a SQL Tuning Set (STS).
DIt always executes triggers that are fired recursively in FULLDML mode.
EIt generates execution plans for each SQL statement in an STS.

How the community answered

(37 responses)

A
78% (29)
B
8% (3)
D
14% (5)

Explanation

Explanation/Reference: https://docs.oracle.com/cd/B19306_01/server.102/e12024/spa.htm

Topics

#SQL Performance Analyzer#SQL Tuning Set#execution plan comparison#regression analysis

Community Discussion

No community discussion yet for this question.

Full 1Z0-074 Practice