Oracle 11G OCP 1Z0-053 40

（40）Evaluate the following code:

SQL>VARIABLE task_name VARCHAR2(255); SQL>VARIABLE sql_stmt VARCHAR2(4000); SQL>BEGIN   :sql_stmt := 'SELECT COUNT(*) FROM customers WHERE cust_state_province=''CA''';   :task_name := 'MY_QUICKTUNE_TASK';   DBMS_ADVISOR.QUICK_TUNE(DBMS_ADVISOR.SQLACCESS_ADVISOR,  :task_name, :sql_stmt); END;

What is the outcome of this block of code?

A. It creates a task and workload,and executes the task.

B. It creates a task and workload but does not execute the task.

C. It produces an error because a template has not been created.

D. It produces an error because the SQL Tuning Set has not been created.

答案：（A）

解析：

參考DBMS_ADVISOR.QUICK_TUNE過程

來自 “ ITPUB部落格 ” ，連結：http://blog.itpub.net/17013648/viewspace-1249579/，如需轉載，請註明出處，否則將追究法律責任。