Evaluate the following code:SQL>VARIABLE task_name VARCHAR2(255)SQL>VARIABLE sql_stmt VARCHAR2(4000);SQL>BEGIN -: sql_st
Posted: Sun Jun 11, 2023 3:50 pm
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. 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