[单选]
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.

社会保险费有养老保险费和（）等失业保险费。医疗保险费。生育保险费。工伤保险费。与鲁迅的《狂人日记》有相似之处的小说是（）马原的《虚构》。余华的《现实一种》。林白的《回廊之椅》。残雪的《山上的小屋》。模板工程的质量通病有（）。梁模板质量通病。柱模板质量通病。墙模板质量通病。板模板质量通病。 Manually， you set the consumer group of all of the newly created users to MYDB_GRP. You want the users to be able to change their consumer groups as per the application requirement. What was the first step that was needed in the process to achieve this objective？（） The user must have been granted the DBA role.。 The user must have been granted the switch privilege as a part of a role.。 The user must have been granted the Resource Manager administrator privilege.。 The user must have been granted the switch privilege by using the DBMS_RESOURCE_MANAGER_PRIVS package.。（）等应当开展家庭美德和反家庭暴力宣传。广播。电视。报刊。网络。

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？（）

参考答案：

● 参考解析

本题暂无解析

当前位置：1Z0-053题库

相关题目: