可学答题网 > 问答 > 1Z0-053题库
目录: 标题| 题干| 答案| 搜索| 相关
问题

Evaluate the following&ensp


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题库