单选题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 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?()
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 user
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.
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 creationB. The procedure must be executed before creating the resources plan directiveC. The SYS_GROUP resource consumer group is not included in the resource plan directiveD. The OTHER_GROUPS resources consumer group is not included in the resource plan directive
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 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 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.
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.
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
多选题You are the network administrator for All network servers run Windows Server 2003. All client computers run Windows XP Professional. You create a folder on thet network and share it as TestKingDocs. You want users to be able to read, create, and modify documents that are stored in the shared folder. You also want users to be able to delete the folders and the files that they create. A user reports that another used deleted a folder that she created. You discover that the Everyone group ias assigned the Allow - Full Control NTFS permission for the folder. You remove all assigned permissions for the Everyone group. You need to configure permission for the TestKingDocs shared folder to meet your requirements. You also need to ensure that users cannot delete the folders and files that other users create. Which two actions should you perform ()(Each correct answer presents part of the solution. Choose two.)AAssign the Authenticated Users group the Allow - Read Execute permission.BAssign the Anonymous group the Allow - Modify permission.CAssign the Creator Owner group the Allow - Modify permission.DAssign the Creator Owner group the Allow - Full Control permission
单选题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 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.
单选题You have a stand-alone computer named Computer1 that runs Windows 7. Several users share Computer1. You need to prevent all users who are members of a group named Group1 from runningWindows Media Player. All other users must be allowed to run Windows Media Player. You must achievethis goal by using the least amount of administrative effort. What should you do?()AFrom Software Restriction Policies, create a path rule.BFrom Software Restriction Policies, create a hash rule.CFrom Application Control Policies, create the default rules.DFrom Application Control Policies, create an executable rule.
单选题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 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?()AConfigure a MailTip.BCreate a transport rule.CCreate a Send connector.DConfigure an expansion server.
单选题You want to enable the user, Scott, to change to the GRP1 consumer group by issuing the following code: SQL EXEC DBMS_SESSION.SWITCH_CURRENT_CONSUMER_GROUP (’SCOTT’, ’GRP1’, FALSE); How will you grant the switch privilege to the user, Scott?()A by using the DBMS_SESSION packageB by granting the DBA roleC by using the DBMS_RESOURCE_MANAGER packageD by using the DBMS_RESOURCE_MANAGER_PRIVS package
单选题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.DThe code will execute successfully but no privilege will be granted to the user, Scott.
单选题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. 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.
单选题You have an organization that contains Exchange Server 2007 and Exchange Server 2010 Hub Transport servers.You create a moderated distribution group named Group1. You assign a user named User1 as the group’s mderator.User1 reports that some e-mails are delivered to members of Group1 without his approval.You need to ensure that all e-mails delivered to Group1 are approved by user1. What should you do?()AModify the expansion server for the group.BRestart the MSExchangeTransport Service.CForce a replication between all domain controllers.DRecreate the group as a dynamic distribution group.
单选题A user named User1 uses a shared computer that runs Windows 7. User1 is a member of group namedGroup1. The computer contains a folder named Folder1. You need to configure the permissions on Folder1to meet the following requirements: User1 must be allowed to delete all files in Folder1 Members of Group1 must be able to create files in Folder1 All other members of Group1 must be prevented from deleting files they did not create in Folder1All users must be prevented from modifying the permissions on Folder1. What should you do?()AAssign Group1 the Write permission. Assign User1 the Modify permission.BAssign Group1 the Modify permission. Assign User1 the Write permission.CDeny Group1 the Write permission. Assign User1 the Modify permission.DDeny Group1 the Modify permission. Assign User1 the Write permission.
单选题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
多选题In your production database, you have multiple resource plan directives that refer to the consumer group DB_GRP. Which two statements are correct?()AThe parallel degree limit for DB_GRP will be the minimum of all the incoming values.BThe parallel degree limit for DB_GRP will be the maximum of all the incoming values.CThe maximum estimated execution time for DB_GRP would be the most nonrestrictive of all incoming values.DIf a session switched from the DB_GRP consumer group to another consumer group because it exceeded the prescribed switch time, then that session would not execute if the active session pool for the new consumer group was full.EIf a session switched from the DB_GRP consumer group to another consumer group because it exceeded the prescribed switch time, then that session would execute even if the active session pool for the new consumer group was full.
单选题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.