违法和不良信息举报 联系客服
免费注册 登录

You execute the following block of code：   SQL>BEGIN   DBMS_

题目
单选题
You execute the following block of code：   SQL>BEGIN   DBMS_RESOURCE_MANAGER.CREATE_SIMPLE_PLAN   （ SIMPLE_PLAN => ’DEPARTMENTS’，   CONSUMER_GROUP1 => ’PAYROLLL’，   GROUP1_CPU => 50，   CONSUMER_GROUP2 => ’SALES’，   GROUP2_CPU => 25，   CONSUMER_GROUP3 => ’MARKETING’，   GROUP3_CPU => 25）；   END；   SQL>/   What is a prerequisite for using the simple resource plan created by executing the above code？（）
A

 You must assign users to consumer groups.

B

 You must grant the switch privilege to the users.

C

 You must create a resource plan directive.

D

 You must specify the complex resource plan.

如果没有搜索结果或未解决您的问题，请直接 联系老师 获取答案。
相似问题和答案

第1题：

To generate recommendations to improve the performance of a set of SQL queries in an application, you execute the following blocks of code:The blocks of code execute successfully; however, you do not get the required outcome. What could be the reason?（）

A. A template needs to be associated with the task.

B.A workload needs to be associated with the task.

C. The partial or complete workload scope needs to be associated with the task.

D. The type of structures (indexes, materialized views, or partitions) to be recommended need to be specified for the task.


参考答案：B

第2题：

You upgrade your Oracle database in a multiprocessor environment. As a recommended you execute thefollowing script:SQL > @utlrp.sqlWhich two actions does the script perform?()

A. Parallel compilation of only the stored PL/SQL code

B. Sequential recompilation of only the stored PL/SQL code

C. Parallel recompilation of any stored PL/SQL code

D. Sequential recompilation of any stored PL/SQL code

E. Parallel recompilation of Java code

F. Sequential recompilation of Java code


参考答案：C, E

第3题：

You have an SQL query that takes one minute to execute. You use the following code segment to execute theSQL query asynchronously.Dim ar As IAsyncResult = cmd.BeginExecuteReader()You need to execute a method named DoWork() that takes one second to run while the SQL query is executing.DoWork() must run as many times as possible while the SQL query is executing.Which code segment should you use?（）

A.

B.

C.

D.


参考答案：B

第4题：

Your organization decided to upgrade the existing Oracle 10g database to Oracle 11g database in a multiprocessor environment. At the end of the upgrade，you observe that the DBA executes the following script：   SQL> @utlrp.sql   What is the significance of executing this script？（）  

  • A、 It performs parallel recompilation of only the stored PL/SQL code.
  • B、 It performs sequential recompilation of only the stored PL/SQL code.
  • C、 It performs parallel recompilation of any stored PL/SQL as well as Java code.
  • D、 It performs sequential recompilation of any stored PL/SQL as well as Java code.

正确答案:C

第5题：

You accepted the recommended SQL Profile by executing the following code：   DECLARE   sqlprofile_name varchar2（30）；  BEGIN   sqlprofile_name ：= DBMS_SQLTUNE.ACCEPT_SQL_PROFILE（  task_name => ’my_task’，   profile_name => ’my_profile’）；   END；   Which advisor will analyze this profile？（）  

  • A、 SQL Access Advisor
  • B、 Undo Advisor
  • C、 Segment Advisor
  • D、 SQL Tuning Advisor

正确答案:D

第6题：

Your organization decided to upgrade the existing Oracle 10g database to Oracle 11g database in a multiprocessor environment. At the end of the upgrade, you observe that the DBA executes the following script:SQL> @utlrp.sqlWhat is the significance of executing this script?（）

A. It performs parallel recompilation of only the stored PL/SQL code.

B. It performs sequential recompilation of only the stored PL/SQL code.

C. It performs parallel recompilation of any stored PL/SQL as well as Java code.

D. It performs sequential recompilation of any stored PL/SQL as well as Java code.


参考答案：C

第7题：

You are creating a new JSP page and you need to execute some code that acts when the page is firstexecuted， but only once. Which three are possible mechanisms for performing this initialization code？（）

  • A、In the init method.
  • B、In the jspInit method.
  • C、In the constructor of the JSP’s Java code.
  • D、In a JSP declaration， which includes an initializer block.
  • E、In a JSP declaration， which includes a static initializer block.

正确答案:B,D,E

第8题：

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

第9题：

Where can you add your own PL/SQL code in relation-handling triggers?（）

  • A、Before the "End default relation program section" comment. 
  • B、After the "Begin default relation program section" comment. 
  • C、Before the "Begin default relation program section" comment. 
  • D、It is not possible to modify the relation-handling code that Forms automatically creates for relations.

正确答案:C

第10题：

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

更多相关问题
相关内容