网友您好， 请在下方输入框内输入要搜索的题目：
题目内容
（请给出正确答案）
单选题
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
参考答案
参考解析
解析：
暂无解析
更多 “单选题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” 相关考题
考题
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，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
考题
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.
考题
You recently activated a resource plan named OLTP_PLAN in your database. Several users are concurrently running long transactions. You decide to monitor the resource manager to determine if the resource allocation formulated in the OLTP_PLAN is sufficient for peak database hours. Which dynamic performance view should you use to display the CPU time consumed by all the sessions within the resource groups？（） A、 V$SYSSTATB、 V$SESSSTATC、 V$RSRC_PLAND、 V$RSRC_CONSUMER_GROUP
考题
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 creating the simple resource plan using the DBMS_RESOURCE_MANAGER.CREATE_SIMPLE_PLAN procedure. Which resource allocation policy will be used for the resource plan？（） A、 RATIOB、 EMPHASISC、 ACTIVE_SESS_POOL_MTHD、 RESOURCE_DEGREE_LIMIT_ABSOLUTE
考题
Which statement is true while creating subplans using Resource Manager？（）A、 The subplan must belong to the consumer group， SYS_GROUP.B、 The total CPU usage at any given level must be less than 100%.C、 The subplans can be used to restrict the degree of parallelism for a user.D、 You can use a resource plan instead of a consumer group to implement a priority ranking within the 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.
考题
For which two situations would you use functionality provided by the Resource Manager？（）A、 setting idle timeout limits on resource plansB、 saving storage space by using compressed backup setsC、 creating jobs that will run automatically at a scheduled timeD、 assigning priorities to jobs to manage access to system resourcesE、 creating alerts to perform notification when tablespaces are low on available space resources
考题
You work as the enterprise exchange administrator at Company.com.The Company.com network consists of a single Active Directory domain named Company.com.Company.com has an Exchange Server 2010 organization.You have received instructions from the CIO to support Autodiscover from the Internet by creating a resource record in DNS.What should you do？（）A、You should consider creating a Host （A） resource record.B、You should consider creating a Text （TXT） resource record.C、You should consider creating a Pointer （PTR） resource record.D、You should consider creating a Mail exchange （MX） resource record.
考题
单选题You are creating the simple resource plan using the DBMS_RESOURCE_MANAGER.CREATE_SIMPLE_PLAN procedure. Which resource allocation policy will be used for the resource plan？（）A
RATIOB
EMPHASISC
ACTIVE_SESS_POOL_MTHD
RESOURCE_DEGREE_LIMIT_ABSOLUTE
考题
单选题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
考题
单选题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 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 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/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 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 userE
grant the ADMINISTER_RESOURCE_MANAGER privilege to the user by using the DBMS_RESOURCE_MANAGER_PRIVS package
考题
单选题You are using the Database Resource Manager to manage database resources. You created a resource plan directive for the MANAGERS resource consumer group under the SALES_PLAN by using the following statement： SQLEXEC DBMS_RESOURCE_MANAGER.CREATE_PLAN_DIRECTIVE （PLAN = ’SALES_PLAN’， GROUP_OR_SUBPLAN = ’MANAGERS’， CPU_P1 = 100， CPU_P2 =0， SWITCH_GROUP = ’CLERKS’， SWITCH_TIME_IN_CALL = 600）； A user， SCOTT， who is assigned to the MANAGERS group， starts a database session and executes a query on the database. What is the outcome if the query takes approximately 15 minutes to complete？（）A
The query starts under the CLERKS group and the user， SCOTT， switches back to the MANAGERS group after the query completes.B
The query starts under the MANAGERS group but terminates with an error when the execution time exceeds 10 minutes.C
The query starts under the MANAGERS group and switches automatically to the CLERKS group when the execution time exceeds 10 minutes. The query does not switch back to the MANAGERS group after the query completes.D
The query starts under the MANAGERS group， the user SCOTT switches automatically to the CLERKS group when the execution time exceeds 10 minutes， and then switches back to the MANAGERS group after the query completes.
考题
单选题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.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
考题
单选题You have created a resource plan， DB_PLAN， using DBMS_RESOURCE_MANAGER.CREATE_SIMPLE_PLAN and you want to impose a restriction on utilization of resources by the database users. Which step must be performed before you can start using the resource plan？（）A
assign users to consumer groupsB
set the resource plan for the instanceC
configure a simple resource plan and specify plan directivesD
configure a complex resource plan and specify plan directives
考题
单选题Which statement is true while creating subplans using Resource Manager？（）A
The subplan must belong to the consumer group， SYS_GROUP.B
The total CPU usage at any given level must be less than 100%.C
The subplans can be used to restrict the degree of parallelism for a user.D
You can use a resource plan instead of a consumer group to implement a priority ranking within the plan.
考题
单选题You updated the resource plan directive for the resource consumer group， DSS_USERS. The resource plan directive is assigned to the DSS_PLAN by using the following statement： SQLEXEC DBMS_RESOURCE_MANAGER.UPDATE_PLAN_DIRECTIVE （PLAN = ’DSS_PLAN’， GROUP_OR_SUBPLAN = ’DSS_USERS’， NEW_CPU_P1 = 80， NEW_SWITCH_GROUP = ’CANCEL_SQL’， NEW_SWITCH_ESTIMATE = TRUE， NEW_SWITCH_TIME = 600）； A user connects to the database and starts an operation. What is the outcome if Oracle estimates that the execution time for this operation will exceed 600 seconds？（）A
The session is killed before starting the operation.B
The session generates an error before starting the operation.C
The session switches to the CANCEL_SQL resource consumer group before starting the operation.D
The session hangs before starting the operation.
考题
单选题You have created a resource plan， DB_PLAN， using DBMS_RESOURCE_MANAGER.CREATE_SIMPLE_PLAN and you want to impose a restriction on utilization of resources by the database users. Which step must be performed before you can start using the resource plan？（）A
assign users to consumer groupsB
set the resource plan for the instanceC
configure a simple resource plan and specify plan directivesD
configure a complex resource plan and specify plan directives
考题
单选题You have created a resource plan， PROD_DB_PLAN， that uses the RATIO policy. The following consumer groups and their respective plan directives have been assigned to this resource plan： Consumer group HIGH_CG with CPU_P1 as 10. Consumer group MEDIUM_CG with CPU_P1 as 5. Consumer group LOW_CG with CPU_P1 as 2. Consumer group OTHER_GROUPS with CPU_P1 as 1. Which statement is correct in this scenario？（）A
The CPU allocation would be equal between the HIGH_CG and MEDIUM_CG consumer groups if there are no sessions existing for the LOW_CG and OTHER_GROUPS consumer groups.B
The members of the HIGH_CG consumer group would get 10% of the CPU.C
The plan PROD_DB_PLAN can have subplans.D
The CPU allocation for the consumer groups would be based on the ratio defined for the CPU_P1.
考题
单选题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.
热门标签
最新试卷
