You want to create a consumer group, GROUP1, and you execute

题目
单选题
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

参考答案和解析
正确答案: B
解析: 暂无解析
如果没有搜索结果或未解决您的问题,请直接 联系老师 获取答案。
相似问题和答案

第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 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

第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题:

our network contains a server that runs window server 2008. The serve has the network policy server(NPS) service 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 connection 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 acces granted. Set the processing of the policy to 3.

正确答案:C

第5题:

You have a computer that runs Windows XP Professional. The computer is joined to an Active Directory domain. The domain contains a global group named Group1. You share a folder named Folder1 on the computer. You modify the NTFS permissions on Folder1 to assign Full Control to Group1. Users from Group1 report that they are unable to add files to Folder1 from the network. You need to ensure that members of Group1 can add files to Folder1 from the network. What should you do?() 

  • A、Add Group1 to the Power Users group.
  • B、Add Group1 to the HelpServicesGroup.
  • C、Modify the share permissions on Folder1.  
  • D、Enable simple file sharing and modify the NTFS permissions on Folder1. 

正确答案:C

第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题:

You issue the following code:    EXEC DBMS_RESOURCE_MANAGER_PRIVS.GRANT_SWITCH_CONSUMER_GROUP        (’SCOTT’ ’GRP1’, TRUE);   What will be the result of executing the above code?()  

  • A、 The switch privilege will be granted to the user, Scott, for changing the consumer group to GRP1.
  • B、 The switch privilege will be granted to the user, Scott, for changing the consumer group from GRP1 to any other group.
  • C、 The code will not execute successfully because there is no GRANT_SWITCH_CONSUMER_GROUP procedure in the DBMS_RESOURCE_MANAGER_PRIVS package.
  • D、The code will execute successfully but no privilege will be granted to the user, Scott.

正确答案:A

第8题:

View the Exhibit and examine the steps that you executed to create a database resource plan. Subsequently, you execute the following procedure which results in an error:SQL> EXECUTE dbms_resources_manager.validate_pending_area ( );What could be the reason?()

A. The pending area is automatically submitted after the plan creation

B. The procedure must be executed before creating the resources plan directive

C. The SYS_GROUP resource consumer group is not included in the resource plan directive

D. The OTHER_GROUPS resources consumer group is not included in the resource plan directive


参考答案:D

第9题:

You have an Exchange Server 2010 organization.The organization contains a distribution group named Group1.You need to ensure that a user named User1 can review and approve all messages sent to Group1.You must prevent User1 from modifying the membership of Group1.  What should you do?()

  • A、Add User1 to Group1 Managed by list
  • B、Assign User1 as a group moderator for Group1.
  • C、Assign the Message Tracking management role to User1.
  • D、Add User1 to Group1 and then create a new journal rule.

正确答案:B

第10题:

You have an Exchange Server 2010 organization.You have a group named Group1 that contains 10,000 members.You need to ensure that an informative message is displayed when users add Group1 to the recipient list of an e-mail message. What should you do?()

  • A、Configure a MailTip.
  • B、Create a transport rule.
  • C、Create a Send connector.
  • D、Configure an expansion server.

正确答案:A

更多相关问题