Which three are true about the SQL Tuning Advisor? (Choose three.)

The correct answer is A. It checks each query being analyzed for stale statistics. B. It checks each query being analyzed for missing statistics. D. It can recommend semantic changes to SQL statements. https://docs.oracle.com/en/database/oracle/oracle-database/18/tgsql/sql-tuning- advisor.html#GUID-73AB38C1-A7F6-401E-9010-B4476E173673

Manage Database Performance

Question

Options

AIt checks each query being analyzed for stale statistics.
BIt checks each query being analyzed for missing statistics.
CIt only recommends syntactic changes to SQL statements.
DIt can recommend semantic changes to SQL statements.
EIt considers all SQL statements being analyzed by the advisor task as a group.
FIt builds SQL profiles for each poorly performing SQL statement to prevent regressions.

How the community answered

(19 responses)

A
84% (16)
C
11% (2)
F
5% (1)

Explanation

https://docs.oracle.com/en/database/oracle/oracle-database/18/tgsql/sql-tuning- advisor.html#GUID-73AB38C1-A7F6-401E-9010-B4476E173673

Topics

#SQL Tuning Advisor#SQL profiles#missing statistics#semantic SQL changes

Community Discussion

No community discussion yet for this question.

Full 1Z0-083 Practice