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. 
Answer: A 

http://docs.oracle.com/cd/E11882_01/appdev.112/e40758/d_advis.htm#ARPLS65139

QUICK_TUNE Procedure

This procedure performs an analysis and generates recommendations for a single SQL statement.

This provides a shortcut method of all necessary operations to analyze the specified SQL statement. The operation creates a task using the specified task name. The task will be created using a specified Advisor task template. Finally, the task will be executed and the results will be saved in the repository.