Evaluate the following code： SQL>VARIABLE task_name V

单项选择题

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.

1Z0-053