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

单选题You want to create a consumer group， GROUP1， and you execute the following command in the command-line interface：  SQL EXEC DBMS_RESOURCE_MANAGER.CREATE_CONSUMER_GROUP （CONSUMER_GROUP =’group1’， COMMENT = ’New Group’）；  This command errorsout displayin

题目
单选题
You want to create a consumer group， GROUP1， and you execute the following command in the command-line interface：  SQL> EXEC DBMS_RESOURCE_MANAGER.CREATE_CONSUMER_GROUP （CONSUMER_GROUP =>’group1’， COMMENT => ’New Group’）；  This command errorsout displaying the following message：  ERROR at line 1：  ORA-01031： insufficient privileges  ORA-06512： at "SYS.DBMS_RMIN"， line 115  ORA-06512： at SYS.DBMS_RESOURCE_MANAGER"， line 108 ORA-06512： at line 1  What action would you take to overcome this error？（）
A

 grant SYSDBA to the user

B

 grant SYSOPER to the user

C

 grant the RESOURCE role to the user

D

 use the GRANT command to grant the ADMINISTER_RESOURCE_MANAGER privilege to the use

E

 grant the ADMINISTER_RESOURCE_MANAGER privilege to the user by using the DBMS_RESOURCE_MANAGER_PRIVS package

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

第1题：

Youwanttocreateaconsumergroup，GROUP1，andyouexecutethefollowingcommandinthecommand-lineinterface：SQL>EXECDBMS_RESOURCE_MANAGER.CREATE_CONSUMER_GROUP（CONSUMER_GROUP=>’group1’，COMMENT=>’NewGroup’）；Thiscommanderrorsoutdisplayingthefollowingmessage：ERRORatline1：ORA-29371：pendingareaisnotactiveORA-06512：at"SYS.DBMS_RMIN"，line115ORA-06512：at"SYS.DBMS_RESOURCE_MANAGER"，line108ORA-06512：atline1Whatactionwouldyoutaketoovercomethiserror？（）

A.activatethePendingAreabeforecreatingtheconsumergroup

B.createthePendingAreabeforecreatingtheconsumergroup

C.increasethesizeofthedatabasebuffercachetoaccommodatethePendingArea

D.increasethesizeofthesharedpooltoaccommodatethePendingArea

E.increasethesizeofthelargepooltoaccommodatethePendingArea


参考答案：B

第2题：

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.

正确答案:A

第3题：

Your network contains a server that runs Windows Server 2008 R2. The server has the Network Policy and Access Services server role installed. You need to allow only members of a global group named Group1 VPN access to the network.What should you do? （）

A. Add Group1 to the RAS and IAS Servers group.

B. Add Group1 to the Network Configuration Operators group.

C. Create a new network policy and define a group-based condition for Group1. Set the access permission of the policy to Access granted. Set the processing order of the policy to 1.

D. Create a new network policy and define a group-based condition for Group1. Set the access permission of the policy to Access granted. Set the processing order of the policy to 3.


参考答案：C

第4题：

You want to create a consumer group， GROUP1， and you execute the following command in the command/x7fline interface：  SQL> EXEC DBMS_RESOURCE_MANAGER.CREATE_CONSUMER_GROUP  （CONSUMER_GROUP =>’group1’， COMMENT => ’New Group’）;  This command errors out displaying the following message：  ERROR at line 1：  ORA/x7f29371： pending area is not active  ORA/x7f06512： at "SYS.DBMS_RMIN"， line 115  ORA/x7f06512： at "SYS.DBMS_RESOURCE_MANAGER"， line 108  ORA/x7f06512： at line 1  What action would you take to overcome this error？（）

  • A、create the Pending Area before creating the consumer group
  • B、activate the Pending Area before creating the consumer group
  • C、increase the size of the large pool to accommodate the Pending Area
  • D、increase the size of the shared pool to accommodate the Pending Area
  • E、increase the size of the database buffer cache to accommodate the Pending Area

正确答案:A

第5题：

You are creating a job class. You have issued the following command to create the job class：  SQL> BEGIN   DBMS_SCHEDULER.CREATE_JOB_CLASS（        JOB_CLASS_NAME => ’LOW_PRIORITY_CLASS’，        RESOURCE_CONSUMER_GROUP => ’LOW_GROUP’，        LOGGING_LEVEL => DBMS_SCHEDULER.LOGGING_FULL，        LOG_HISTORY => 1200，   COMMENTS => ’LOW JOB PRIORITY CLASS’）；        END；        SQL> /   What will be the result of the above command？（）

  • A、 The command will be executed successfully.
  • B、 The command will fail because RESOURCE_CONSUMER_GROUP is an invalid parameter in the  DBMS_SCHEDULER.CREATE_JOB_CLASS procedure.
  • C、 The command will fail because LOGGING_LEVEL is an invalid parameter in the DBMS_SCHEDULER.CREATE_JOB_CLASS procedure.
  • D、 The command will fail because LOG_HISTORY is an invalid parameter in the DBMS_SCHEDULER.CREATE_JOB_CLASS procedure.
  • E、 The command will fail because 1200 is an invalid value for the LOG_HISTORY parameter in the  DBMS_SCHEDULER.CREATE_JOB_CLASS procedure.

正确答案:E

第6题：

You are creating a resource consumer group using the DBMS_RESOURCE_MANAGER.CREATE_CONSUMER_GROUP procedure. Which parameter will you use to define the resource scheduling method used between sessions within the resource group？（） 

  • A、 CPU_MTH
  • B、 NEW_CPU_MTH
  • C、 CPU_P1
  • D、 CPU_P2

正确答案:A

第7题：

In your Automatic Storage Management （ASM） instance， one of the nonempty disk groups， DGROUP1， is no longer required and you want this disk group to be removed. You execute the following command to achieve this objective：  DROP DISKGROUP dgroup1 EXCLUDING CONTENTS；  What would be the result of this command？（）

  • A、 This command would result in an error because the disk group is not empty.
  • B、 The command would distribute the contents of the specified disk group among all other disk groups and then drop the specified disk group.
  • C、 The command would result in the contents being moved to the parent disk group and dropping of the disk group.
  • D、 The command would result in the disk group being marked as INVALID because it cannot be dropped.
  • E、 The command would drop the disk group， ignoring the EXCLUDING CONTENTS option.

正确答案:A

第8题：

Youwanttocreateaconsumergroup，GROUP1，andyouexecutethefollowingcommandinthecommandlineinterface：SQL>EXECDBMS_RESOURCE_MANAGER.CREATE_CONSUMER_GROUP（CONSUMER_GROUP=>’group1’，COMMENT=>’NewGroup’）Thiscommanderrorsoutdisplayingthefollowingmessage：ERRORatline1：ORA01031：insufficientprivilegesORA06512：at"SYS.DBMS_RMIN"，line115ORA06512：atSYS.DBMS_RESOURCE_MANAGER"，line108ORA06512：atline1Whatactionwouldyoutaketoovercomethiserror？（）

A.grantSYSDBAtotheuser

B.grantSYSOPERtotheuser

C.granttheRESOURCEroletotheuser

D.usetheGRANTcommandtogranttheADMINISTER_RESOURCE_MANAGERprivilegetotheuser

E.granttheADMINISTER_RESOURCE_MANAGERprivilegetotheuserbyusingthe DBMS_RESOURCE_MANAGER_PRIVSpackage


参考答案：E

第9题：

You want to create a consumer group， GROUP1， and you execute the following command in the command-line interface：  SQL> EXEC DBMS_RESOURCE_MANAGER.CREATE_CONSUMER_GROUP （CONSUMER_GROUP =>’group1’， COMMENT => ’New Group’）；  This command errorsout displaying the following message：  ERROR at line 1：  ORA-01031： insufficient privileges  ORA-06512： at "SYS.DBMS_RMIN"， line 115  ORA-06512： at SYS.DBMS_RESOURCE_MANAGER"， line 108 ORA-06512： at line 1  What action would you take to overcome this error？（）

  • A、 grant SYSDBA to the user
  • B、 grant SYSOPER to the user
  • C、 grant the RESOURCE role to the user
  • D、 use the GRANT command to grant the ADMINISTER_RESOURCE_MANAGER privilege to the use
  • E、 grant the ADMINISTER_RESOURCE_MANAGER privilege to the user by using the DBMS_RESOURCE_MANAGER_PRIVS package

正确答案:E

第10题：

You have an enterprise subordinate certification authority （CA）. You have a group named  Group1.     You need to allow members of Group1 to publish new certificate revocation lists. Members of  Group1 must not be allowed to revoke certificates.     What should you do（）

  • A、Add Group1 to the local Administrators group.
  • B、Add Group1 to the Certificate Publishers group.
  • C、Assign the Manage CA permission to Group1.
  • D、Assign the Issue and Manage Certificates permission to Group1.

正确答案:C

更多相关问题
相关内容