What can be automatically implemented after the SQL Tuning Advisor is run as part of the
Automated Maintenance Task?
A.
statistics recommendations
B.
SQL profile recommendations
C.
SQL statement restructure recommendations
D.
creation of materialized views to improve query performance
Explanation:
B
A. Wrong. statistics recommendations is part of Automatic Optimizer Statistics Collection, not of SQL Tuning Advisor
B. Wrong. “A SQL profile is a database object that contains auxiliary statistics specific to a SQL statement. Conceptually, a SQL profile is to a SQL statement what object-level statistics are to a table or index. SQL profiles are created when a DBA invokes SQL Tuning Advisor.”
D. Wrong. The SQL Access Advisor analyzes the entire workload and recommends the creation of materialized views.