网友您好, 请在下方输入框内输入要搜索的题目:

题目内容 (请给出正确答案)
单选题
Manually, you set the consumer group of all of the newly created users to MYDB_GRP. You want the users to be able to change their consumer groups as per the application requirement. What was the first step that was needed in the process to achieve this objective?()
A

 The user must have been granted the DBA role.

B

 The user must have been granted the switch privilege as a part of a role.

C

 The user must have been granted the Resource Manager administrator privilege.

D

 The user must have been granted the switch privilege by using the DBMS_RESOURCE_MANAGER_PRIVS package.


参考答案

参考解析
解析: 暂无解析
更多 “单选题Manually, you set the consumer group of all of the newly created users to MYDB_GRP. You want the users to be able to change their consumer groups as per the application requirement. What was the first step that was needed in the process to achieve this objective?()A  The user must have been granted the DBA role.B  The user must have been granted the switch privilege as a part of a role.C  The user must have been granted the Resource Manager administrator privilege.D  The user must have been granted the switch privilege by using the DBMS_RESOURCE_MANAGER_PRIVS package.” 相关考题
考题 Your network contains a Windows Server Update Services (WSUS) server.You have an organizational unit (OU) named Sales. The Sales OU contains all of the computer objects for the sales department. You enable client-side targeting for the Sales OU and set the target group name to Sales-Computers.You restart a sales computer.You discover that the computer is not added to the Sales-Computer computer group in WSUS.You need to ensure that all sales computers are added to the Sales-Computers group.Which options should you configure?()A. Automatic ApprovalsB. ComputersC. PersonalizationD. Products and Classifications

考题 You are the administrator of the homeoffice.local domain. You want to create a shared printer for the company's executives so that they do not have to wait for their documents to print when the default printer's queue contains a large number of documents.You configure the new high-priority printer and want to set permissions for the groups shown in the exhibit. Note: The default settings have been cleared.You select the check box to allow Print permission for the Executives group. You want only the Administrators, Print Operators, Server Operators, and Executives group to be able to print to the printer. What can you do? (Select all that apply).A.Remove the Everyone group.B.Select the check box to deny Print permission for the Everyone group.C.Select the check box to deny Manage Documents permission for Everyone group.D.Select all Deny check boxes for the Everyone group.E.Clear all check boxes for Everyone group.

考题 You have created a resource plan, PROD_DB_PLAN, with the following consumer groups with the respective plan directives:  Consumer group SALESwith CPU_P1as 60 and DEGREE_OF_PARALLELISMas 4.   Consumer group MARKETwith CPU_P1as 20.   Consumer group DEVwith CPU_P1as 20.   Consumer groupOTHERSwith CPU_P1as 0 and CPU_P2as 100.  Which two statements are correct in this scenario?()A、 The maximum degree of parallelism for the members of the consumer groups is 4.B、 The CPU allocation will always be equal for the consumer groups MARKET and DEV.C、 The OTHERS consumer group would get 100% of the CPU if there are unused level 1 CPU resources.D、 The SALES and MARKET consumer groups would get 100% of the CPU if there are unused level 2 CPU resources.E、 The maximum degree of parallelism for the members of the consumer group SALES is 4 with no restriction for the remaining groups.

考题 You have created a resource plan, PROD_DB_PLAN, with the following consumer groups with the respective plan directives:  Consumer group SALES with CPU_P1 as 60 and DEGREE_OF_PARALLELISM as 4. Consumer group MARKET with CPU_P1 as 20.  Consumer group DEV with CPU_P1 as 20.  Consumer group OTHERS with CPU_P1 as 0 and CPU_P2 as 100.  Which two statements are correct in this scenario? ()A、The maximum degree of parallelism for the members of the consumer groups is 4.B、The CPU allocation will always be equal for the consumer groups MARKET and DEV.C、The OTHERS consumer group would get 100% of the CPU if there are unused level 1 CPU resources.D、The SALES and MARKET consumer groups would get 100% of the CPU if there are unused level 2 CPU resources.E、The maximum degree of parallelism for the members of the consumer group SALES is 4 with no restriction for the remaining groups.

考题 A companys computer policy dictates that all users workstations must use the companys corporate web page as their default home page.  Which of the following methods should an administrator use to BEST comply with this policy?()A、 Configure a logon script to set the homepage at logon.B、 Set the default homepage to the corporate website in Group Policy.C、 Manually configure the homepage on all workstations and setup trace logs to ensure compliance.D、 Set the default homepage to the corporate website on the base computer image.

考题 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 are managing an Oracle Database 11g ASM instance with a disk group dg01 having three disks. One of the disks in the disk group becomes unavailable because of power failure. You issued the following command to change the DISK_REPAIR_TIME attribute from 3.6 hours to 5 hours: ALTER DISKGROUP dg01 SET ATTRIBUTE 'disk_repair_time' = '5h'; To which disks in the disk group will the new value be applicable?()A、all disks in the disk groupB、all disks that are currently in OFFLINE modeC、all disks that are not currently in OFFLINE modeD、all disks in the disk group only if all of them are ONLINE

考题 You are managing Oracle Database 11g with an ASM storage with high redundancy. The following command was issued to drop the disks from the dga disk group after five hours:   ALTER DISKGROUP dga OFFLINE DISKS IN FAILGROUP f2 DROP AFTER 5H;   Which statement is true in this scenario?()A、 It starts the ASM fast mirror resync.B、 All the disks in the dga disk group would be OFFLINE and the DISK_REPAIR_TIME disk attribute would be set to 5 hours.C、 It drops all disk paths from the dga disk group.D、 All the disks in the dga disk group in failure group f2 would be OFFLINE and the DISK_REPAIR_TIME disk attribute would be set to 5 hours.

考题 From the V$SESSION_LONGOPS view, you find that some of the database users have long/x7frunning queries and are consuming a lot of CPU time. This causes problems for you when you try to log on as the system user and perform small maintenance tasks. You would like to ensure that users SYS and SYSTEM get priority over all other users. Which method would you use to achieve this objective?()A、create a plan directive in the SYS_GROUPB、create the pending area for the consumer groupC、activate the provided SYSTEM_PLAN in Resource ManagerD、set the TIMED_STATISTICS parameter to TRUE in the parameter fileE、set the execution time limit for all users, except SYS and SYSTEM, in their profiles

考题 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 single Active Directory directory service domain. All servers run Windows Server 2003. You create several new Group Policies. You need to determine the end result of these Group Policies before applying the settings.  What should you do?()A、 Use Resultant Set of Policy (RSoP) in Planning mode.B、 Use Resultant Set of Policy (RSoP) in Logging mode.C、 Use Event Viewer to view the system log.D、 Use Event Viewer to view the application log.

考题 Your network consists of a single Active Directory domain. All servers run Windows Server 2008 R2.   You need to recommend a Group Policy deployment strategy. Your strategy must support the following  requirements: èDomain-level Group Policy objects (GPOs) must not be overwritten by organizational unit (OU) level  GPOs.   èOU-level GPOs must not apply to members of the Server Operators group. What should you recommend?() A、Enable Block Inheritance for the domain,and then modify the permissions of all GPOs linked to OUs.B、Enable Block Inheritance for the domain, and then enable Loopback Processing policy mode. Add the Server Operators group to the Restricted Groups list.C、Set all domain level GPOs to Enforced, and then modify the permissions of the GPOs that are linked to  OUs.D、Set all domain level GPOs to Enforced,and then enable Loopback Processing policy mode.Add the server Operators group to the Restricted Groups list.

考题 Your network consists of a single Active Directory domain. The network contains a Terminal Server that runs Windows Server 2008, and client computers that run Windows Vista. All computers are members of the domain.   You deploy an application by using the TS RemoteApp Manager. The Terminal Servers security layer is set to Negotiate.  You need to ensure that domain users are not prompted for credentials when they access the application. What should you do?()A、On the server, modify the Password Policy settings in the local Group Policy.B、On the server, modify the Credential Delegation settings in the local Group Policy.C、On all client computers, modify the Password Policy settings in the local Group Policy.D、On all client computers, modify the Credential Delegation settings in the local Group Policy.

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

考题 单选题Manually, you set the consumer group of all of the newly created users to MYDB_GRP. You want the users to be able to change their consumer groups as per the application requirement. What was the first step that was needed in the process to achieve this objective?()A The user must have been granted the DBA role.B The user must have been granted the switch privilege as a part of a role.C The user must have been granted the Resource Manager administrator privilege.D The user must have been granted the switch privilege 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 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

考题 单选题Your network contains a Windows Server Update Services (WSUS) server.You have an organizational unit (OU) named Sales. The Sales OU contains all of the computer objects for the sales department. You enable client-side targeting for the Sales OU and set the target group name to Sales-Computers.You restart a sales computer.You discover that the computer is not added to the Sales-Computer computer group in WSUS.You need to ensure that all sales computers are added to the Sales-Computers group. Which options should you configure?()A Automatic ApprovalsB ComputersC PersonalizationD Products and Classifications

考题 单选题You are the network administrator for TestKing.com. The network consists of a single Active Directory domain named testking.com. All network servers run Windows Server 2003, and all client computers run Windows XP Professional. All user accounts in the Sales department are located in the Sales organizational unit (OU). You suspect that one or more user accounts in the OU have compromised passwords. You need to force all users in the Sales department to reset their passwords. What should you do?()A Select all user accounts in the Sales OU. Disable the accounts and re-enable them.B Select all user accounts in the Sales OU. Modify the account properties to force all passwords to be changed on next logon.C Create a Group Policy object (GPO) and link it to the Sales OU. Modify the password policy to set the maximum password age to 0.D Create as Group Policy object (GPO) and link it to the domain. Modify the password policy to set the maximum password age to 0.

考题 多选题You have created a resource plan, PROD_DB_PLAN, with the following consumer groups with the respective plan directives:  Consumer group SALES with CPU_P1 as 60 and DEGREE_OF_PARALLELISM as 4. Consumer group MARKET with CPU_P1 as 20.  Consumer group DEV with CPU_P1 as 20.  Consumer group OTHERS with CPU_P1 as 0 and CPU_P2 as 100.  Which two statements are correct in this scenario? ()AThe maximum degree of parallelism for the members of the consumer groups is 4.BThe CPU allocation will always be equal for the consumer groups MARKET and DEV.CThe OTHERS consumer group would get 100% of the CPU if there are unused level 1 CPU resources.DThe SALES and MARKET consumer groups would get 100% of the CPU if there are unused level 2 CPU resources.EThe maximum degree of parallelism for the members of the consumer group SALES is 4 with no restriction for the remaining groups.

考题 单选题You are managing an Oracle Database 11g ASM instance with a disk group dg01 having three disks. One of the disks in the disk group becomes unavailable because of power failure. You issued the following command to change the DISK_REPAIR_TIME attribute from 3.6 hours to 5 hours:   ALTER DISKGROUP dg01 SET ATTRIBUTE ’disk_repair_time’ = ’5h’;   To which disks in the disk group will the new value be applicable?()A  all disks in the disk groupB  all disks that are currently in OFFLINE modeC  all disks that are not currently in OFFLINE modeD  all disks in the disk group only if all of them are ONLINE

考题 多选题In your production database, you have multiple resource plan directives that refer to the customer 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.EIs 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 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 are using Resource Manager to manage system resources. While creating a new database user, you observe that the user is a member of DEFAULT_CONSUMER_GROUP by default. What would be the implications of this?()A The Resource Manager plan does not affect the user.B There must be a plan directive in any of the plans of the group to control the resources.C The members of the group DEFAULT_CONSUMER_GROUP always have resource restrictions.D The members of DEFAULT_CONSUMER_GROUP are restrained from accessing the system tables.E The members of this group can change their group without the database administrator’s intervention.

考题 单选题You have a single Active Directory directory service domain. All servers run Windows Server 2003. You create several new Group Policies. You need to determine the end result of these Group Policies before applying the settings.  What should you do?()A  Use Resultant Set of Policy (RSoP) in Planning mode.B  Use Resultant Set of Policy (RSoP) in Logging mode.C  Use Event Viewer to view the system log.D  Use Event Viewer to view the application log.