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

35.You want the Automatic SQL Tuning process to stop accepting and implementing the recommended

SQL profiles automatically. Which action would you perform to achieve this?

A. Edit the automatic maintenance window group configuration.

B. Set the CURSOR_SHARING parameter to EXACT for the database instance.

C. Use the DBMS_SQLTUNE.SET_TUNING_TASK_PARAMETERS procedure to set ACCEPT_SQL_PROFILES to FALSE.

D. Set the SQLTUNE_CATEGORY parameter to DEFAULT for the database instance.

Answer: C

答案解析：

参考：http://docs.oracle.com/cd/E11882_01/server.112/e41573/sql_tune.htm#PFGRF94849

if want to stop accepting and implementing the recommended SQL profiles automatically

set ACCEPT_SQL_PROFILES to FALSE.

ACCEPT_SQL_PROFILE

Specifies whether to accept SQL profiles automatically.

To configure automatic SQL tuning: 

1. Start SQL*Plus, and connect to the database with DBA privileges (or connect as SYS if you plan to run EXECUTE_AUTO_TUNING_TASK).

2. Run the DBMS_AUTO_SQLTUNE.SET_AUTO_TUNING_TASK_PARAMETER procedure.

   The following example configures the automatic SQL tuning task to automatically accept SQL profiles recommended by SQL Tuning Advisor:

   BEGIN

     DBMS_AUTO_SQLTUNE.SET_AUTO_TUNING_TASK_PARAMETER(

       parameter => 'ACCEPT_SQL_PROFILES', value => 'TRUE');

   END;

   /