Q126. Which three are true about the SQL Tuning Advisor? (Choose three.)
- A. It checks each query being analyzed for stale statistics.
- B. It checks each query being analyzed for missing statistics.
- C. It only recommends syntactic changes to SQL statements.
- D. It can recommend semantic changes to SQL statements.
- E. It considers all SQL statements being analyzed by the advisor task as a group.
- F. It builds SQL profiles for each poorly performing SQL statement to prevent regressions.
Answer: A,B,D
Reference: https://docs.oracle.com/database/121/TGSQL/tgsql_sqltune.htm#TGSQL540
NOT for each poorly performing SQL statement