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 *