Which three functions can be performed by the SQL Tuning Advisor? (Choose three.)
A.
recommending creation of indexes based on SQL workload
B.
recommending restructuring of SQL statements that have suboptimal plans
C.
checking schema objects for missing and state statistics
D.
recommending optimization of materialized views
E.
generating SQL profiles
A, B, E
https://docs.oracle.com/database/121/TGSQL/tgsql_sqltune.htm#TGSQL541
The correct answers should be B, C, and E.
– B is incorrect because the Automatic Tuning Optimizer does not analyze how its index recommendation can affect the entire SQL workload. SQL Access Advisor examines the effect of creating an index on the SQL workload before making recommendations.
– Recommending optimization of materialized views is indeed one of the features of SQL Access Advisor.
I meant to say A is incorrect.
I think ABC
https://docs.oracle.com/database/121/TGSQL/tgsql_sqltune.htm#TGSQL542
Tuning recommendations include:
• Collection of object statistics
• Creation of indexes
• Rewriting SQL statements
• Creation of SQL profiles
• Creation of SQL plan baselines
ABE
B and C and E iguess
Hi, after searching what is a difference between SQL Access and Tunning advisor. The correct answer should be B, C, E.
things about indexes and materialized views are related to SQL Access Advisor.
https://asktom.oracle.com/pls/asktom/asktom.search?tag=difference-between-sql-tuning-advisor-and-sql-access-advisor
Agree with you. SQL Access adviser is about indexing and viewing.