Which two types of recommendations can be provided by the SQL Tuning Advisor?

You created a SQL Tuning Set (STS) containing resource-intensive SQL statements. You plan to
run the SQL Tuning Advisor.
Which two types of recommendations can be provided by the SQL Tuning Advisor?

A.
Semantic restructuring for each SQL statement

B.
Gathering missing or stale statistics at the schema level for the entire workload

C.
Creating a materialized view to benefit from query rewrite for the entire workload

D.
Gathering missing or stale statistics for objects used by the statements.

E.
Creating a partition table to benefit from partition pruning for each statement

Explanation:
The output of the SQL Tuning Advisor is in the form of an advice or
recommendations, along with a rationale for each recommendation and its expected benefit. The
recommendation relates to collection of statistics on objects ( D), creation of new indexes,
restructuring of the SQL statement (A), or creation of a SQL profile. You can choose to accept the
recommendation to complete the tuning of the SQL statements.
Note:
* A SQL Tuning Set can be used as input to the SQL Tuning Advisor, which performs automatic
tuning of the SQL statements based on other input parameters specified by the user.
* A SQL Tuning Set (STS) is a database object that includes one or more SQL statements along
with their execution statistics and execution context, and could include a user priority ranking. The
SQL statements can be loaded into a SQL Tuning Set from different SQL sources, such as the
Automatic Workload Repository, the cursor cache, or custom SQL provided by the user.
Reference: Oracle Database Performance Tuning Guide 11g , SQL Tuning Advisor