单选题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 userB grant SYSOPER to the userC grant the RESOURCE role to the userD use the GRANT command to grant the ADMINISTER_RESOURCE_MANAGER privilege to the useE grant the ADMINISTER_RESOURCE_MANAGER privilege to the user by using the DBMS_RESOURCE_MANAGER_PRIVS package

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


参考解析

解析: 暂无解析

相关考题:

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.

Youwanttocreateaconsumergroup,GROUP1,andyouexecutethefollowingcommandinthecommandlineinterface:SQLEXECDBMS_RESOURCE_MANAGER.CREATE_CONSUMER_GROUP(CONSUMER_GROUP=’group1’,COMMENT=’NewGroup’)Thiscommanderrorsoutdisplayingthefollowingmessage:ERRORatline1:ORA01031:insufficientprivilegesORA06512:atSYS.DBMS_RMIN,line115ORA06512:atSYS.DBMS_RESOURCE_MANAGER,line108ORA06512:atline1Whatactionwouldyoutaketoovercomethiserror?()A.grantSYSDBAtotheuserB.grantSYSOPERtotheuserC.granttheRESOURCEroletotheuserD.usetheGRANTcommandtogranttheADMINISTER_RESOURCE_MANAGERprivilegetotheuserE.granttheADMINISTER_RESOURCE_MANAGERprivilegetotheuserbyusingthe DBMS_RESOURCE_MANAGER_PRIVSpackage

Youwanttocreateaconsumergroup,GROUP1,andyouexecutethefollowingcommandinthecommand-lineinterface:SQLEXECDBMS_RESOURCE_MANAGER.CREATE_CONSUMER_GROUP(CONSUMER_GROUP=’group1’,COMMENT=’NewGroup’);Thiscommanderrorsoutdisplayingthefollowingmessage:ERRORatline1:ORA-29371:pendingareaisnotactiveORA-06512:atSYS.DBMS_RMIN,line115ORA-06512:atSYS.DBMS_RESOURCE_MANAGER,line108ORA-06512:atline1Whatactionwouldyoutaketoovercomethiserror?()A.activatethePendingAreabeforecreatingtheconsumergroupB.createthePendingAreabeforecreatingtheconsumergroupC.increasethesizeofthedatabasebuffercachetoaccommodatethePendingAreaD.increasethesizeofthesharedpooltoaccommodatethePendingAreaE.increasethesizeofthelargepooltoaccommodatethePendingArea

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_MTHB、 NEW_CPU_MTHC、 CPU_P1D、 CPU_P2

You execute the following block of code:   SQLBEGIN   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.

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.

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.

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 userB、 grant SYSOPER to the userC、 grant the RESOURCE role to the userD、 use the GRANT command to grant the ADMINISTER_RESOURCE_MANAGER privilege to the useE、 grant the ADMINISTER_RESOURCE_MANAGER privilege to the user by using the DBMS_RESOURCE_MANAGER_PRIVS package

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 groupB、activate the Pending Area before creating the consumer groupC、increase the size of the large pool to accommodate the Pending AreaD、increase the size of the shared pool to accommodate the Pending AreaE、increase the size of the database buffer cache to accommodate the Pending Area

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.

You have an Exchange Server 2010 organization.  Your companys compliance policy states that the following occurs when a user leaves the company:.The user account is disabled .The user account and mailbox are deleted after six months .All e-mail messages in the mailbox are retained for three years  You need to recommend a solution to retain the e-mail messages of users who leave the company.The solution must meet the following requirements: .Ensure that a group named Group1 can manage the process .Minimize disk space required to store the mailbox databases What should you recommend?()A、Assign the Mailbox Search management role to Group1, and then create a retention policy.B、Assign the Mailbox Search management role to Group1, and then create a managed folder mailbox policy.C、Assign the Mailbox Import Export management role to Group1, and then configure Personal Archives for each mailbox.D、Assign the Mailbox Import Export management role to Group1, and then instruct Group1 to export mailboxes to personal folder (.pst) files.

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 listB、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.

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.

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.

Your network contains a server that runs Windows Server 2008. The server 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 GroupB、Add Group1 to the Network Configuration Operators groupC、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 1D、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 of the policy to 3.

ertkiller .com has purchased laptop computers that will be used to connect to a wireless network. You create a laptop organizational unit and create a Group Policy Object (GPO) and configure user profiles by utilizing the names of approved wireless networks. You link the GPO to the laptop organizational unit. The new laptop users complain to you that they cannot connect to a wireless network.  What should you do to enforce the group policy wireless settings to the laptop computers()A、Execute gpupdate/target:computer command at the command prompt on laptop computersB、Execute Add a network command and leave the SSID (service set identifier) blankC、Execute gpupdate/boot command at the command prompt on laptops computersD、Connect each laptop computer to a wired network and log off the laptop computer and then login again.E、None of the above

单选题Consider the following configuration:  /devices/D1is a member of disk group dgroupA.  /devices/D2is a member of disk group dgroupA.  /devices/D3is a member of disk group dgroupA.  You plan to add a new disk, /devices/D4,to the disk group dgroupA.  You execute the following command:  SQL ALTER DISKGROUP dgroupA ADD DISK ’/devices/D*’;  Which task would be accomplished by the command?()A The command adds the new disk, D4, to the disk group.B The command would result in an error because the is no disk by the name ’/devices/D*’C The command will be ignored because disks starting with D are already members of the disk group.D The command would result in an error because no wildcard characters can be used in the disk name.E The command first detaches all the member disks starting with D, and the reattaches them including the new disk.

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

单选题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_MTHB NEW_CPU_MTHC CPU_P1D CPU_P2

单选题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?()Acreate the Pending Area before creating the consumer groupBactivate the Pending Area before creating the consumer groupCincrease the size of the large pool to accommodate the Pending AreaDincrease the size of the shared pool to accommodate the Pending AreaEincrease the size of the database buffer cache to accommodate the Pending Area

单选题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 errors out displaying the following message:  ERROR at line 1:  ORA-29371: pending area is not active  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 activate the Pending Area before creating the consumer groupB create the Pending Area before creating the consumer groupC increase the size of the database buffer cache to accommodate the Pending AreaD increase the size of the shared pool to accommodate the Pending AreaE increase the size of the large pool to accommodate the Pending Area

单选题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?()AAdd User1 to Group1 Managed by listBAssign User1 as a group moderator for Group1.CAssign the Message Tracking management role to User1.DAdd User1 to Group1 and then create a new journal rule.

单选题You have an Exchange Server 2010 organization.  Your companys compliance policy states that the following occurs when a user leaves the company:.The user account is disabled .The user account and mailbox are deleted after six months  .All e-mail messages in the mailbox are retained for three years  You need to recommend a solution to retain the e-mail messages of users who leave the company.The solution must meet the following requirements: .Ensure that a group named Group1 can manage the process .Minimize disk space required to store the mailbox databases What should you recommend?()AAssign the Mailbox Search management role to Group1, and then create a retention policy.BAssign the Mailbox Search management role to Group1, and then create a managed folder mailbox policy.CAssign the Mailbox Import Export management role to Group1, and then configure Personal Archivesfor each mailbox.DAssign the Mailbox Import Export management role to Group1, and then instruct Group1 to export mailboxes to personal folder (.pst) files.

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

单选题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/x7f01031: insufficient privileges  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?()Agrant SYSDBA to the userBgrant SYSOPER to the userCgrant the RESOURCE role to the userDuse the GRANT command to grant the ADMINISTER_RESOURCE_MANAGER privilege to the userEgrant the ADMINISTER_RESOURCE_MANAGER privilege to the user by using the DBMS_RESOURCE_MANAGER_PRIVS package

单选题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()AAdd Group1 to the local Administrators group.BAdd Group1 to the Certificate Publishers group.CAssign the Manage CA permission to Group1.DAssign the Issue and Manage Certificates permission to Group1.

单选题You execute the following block of code:   SQLBEGIN   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.