274.The SQL Tuning Advisor has been configured with default configurations in your database instance.
Which recommendation is automatically implemented without the DBA's intervention after the SQL Tuning
Advisor is run as part of the AUTOTASK framework?
A. statistics recommendations
B. SQL profile recommendations
C. index-related recommendations
D. restructuring of SQL recommendations
Answer: B
答案解析:
参考:http://docs.oracle.com/cd/E11882_01/server.112/e41573/sql_tune.htm#PFGRF95161
SQL Profile Recommendations
During SQL tuning, you select a statement for automatic tuning and run SQL Tuning Advisor. The database can profile the following types of statement:
-
DML statements (
SELECT
,INSERT
with aSELECT
clause,UPDATE
, andDELETE
) -
CREATE
TABLE
statements (only with theAS
SELECT
clause) -
MERGE
statements (the update or insert operations)
SQL Tuning Advisor invokes Automatic Tuning Optimizer to generate recommendations. Recommendations to accept SQL profiles occur in a finding.