OCP-1Z0-053-V12.02-274题

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 a SELECT clause, UPDATE, and DELETE)

• CREATE TABLE statements (only with the AS 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.