What can be automatically implemented after the SQL Tuning Advisor is run as part of the Automated Maintenance Task?

I also think –> B

The ACCEPT_SQL_PROFILE tuning task parameter specifies whether to implement SQL profiles automatically (true) or require user intervention (false). The default is AUTO, which means true if at least one SQL statement exists with a SQL profile and false if this condition is not satisfied.

When automatic implementation is enabled, the advisor only implements recommendations to create SQL profiles. Recommendations such as creating new indexes, gathering optimizer statistics, and creating SQL plan baselines are not automatically implemented.

Once automatic SQL tuning begins, which by default runs for at most one hour during a maintenance window, the following steps are performed:

…

During the tuning process, all recommendation types are considered and reported, but only SQL profiles can be implemented automatically.

“… automatically implemented…”
https://docs.oracle.com/cd/B28359_01/server.111/b28274/sql_tune.htm#CHDJDFGE

“(…)
2. Tune each SQL statement individually by calling the SQL Tuning Advisor.
During the tuning process, all recommendation types are considered and reported, but only SQL profiles can be implemented automatically.
(…)”

As per,

https://docs.oracle.com/database/121/TGSQL/tgsql_sqltune.htm#TGSQL575

Which says,

”
Generate recommendations and implement SQL profiles automatically

You can configure an Automatic SQL Tuning task to run nightly in maintenance windows. When invoked in this way, the advisor can generate recommendations and also implement SQL profiles automatically
”

Hence, correct answer is B.

From https://docs.oracle.com/database/121/TGSQL/tgsql_sqltune.htm#TGSQL542

Purpose of SQL Tuning Advisor
…..
The recommendations generated by SQL Tuning Advisor help you achieve the following specific goals:

* Avoid labor-intensive manual tuning
….
* Generate recommendations and implement SQL profiles automatically

You can configure an Automatic SQL Tuning task to run nightly in maintenance windows. When invoked in this way, the advisor can generate recommendations and also implement SQL profiles automatically.

So, B.