What is the outcome of this block of code?

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?

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.



Leave a Reply 0

Your email address will not be published. Required fields are marked *