Which three functions are performed by the SQL Tuning Advisor?
A.
Building and implementing SQL profiles
B.
Recommending the optimization of materialized views
C.
Checking query objects for missing and stale statistics
D.
Recommending bitmap, function-based, and B-tree indexes
E.
Recommending the restructuring of SQL queries that are using bad plans
ACE
ADE
http://docs.oracle.com/database/121/TGSQL/tgsql_sqltune.htm#TGSQL542
In fact, ACDE are correct.
SQL Tuning Advisor is a mechanism for resolving problems related to suboptimally performing SQL statements. Use SQL Tuning Advisor to obtain recommendations for improving performance of high-load SQL statements, and prevent regressions by only executing optimal plans.
Tuning recommendations include:
– Collection of object statistics – (C)
– Creation of indexes – (D)
– Rewriting SQL statements – (E)
– Creation of SQL profiles – (A)
– Creation of SQL plan baselines
Source: http://docs.oracle.com/database/121/TGSQL/tgsql_sqltune.htm#TGSQL542
B and D are wrong
This functions are SQL Access Advisor
https://docs.oracle.com/database/121/TGSQL/tgsql_sqlaccess.htm#TGSQL591
See:
Indexes
SQL Access Advisor index recommendations include bitmap, function-based, and B-tree indexes. A bitmap index offers a reduced response time for many types of ad hoc queries and reduced storage requirements compared to other indexing techniques. B-tree indexes are most commonly used in a data warehouse to index unique or near-unique keys. SQL Access Advisor materialized view recommendations include fast refreshable and full refreshable MVs, for either general rewrite or exact text match rewrite.
Materialized views
SQL Access Advisor, using the TUNE_MVIEW procedure, also recommends how to optimize materialized views so that they can be fast refreshable and take advantage of general query rewrite.