The session is killed before starting the operation.
The session generates an error before starting the operation.
The session switches to the CANCEL_SQL resource consumer group before starting the operation.
The session hangs before starting the operation.
第1题:
Youupdatedtheresourceplandirectivefortheresourceconsumergroup,DSS_USERS.TheresourceplandirectiveisassignedtotheDSS_PLANbyusingthefollowingstatement:
SQL>EXECDBMS_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);
Auserconnectstothedatabaseandstartsanoperation.WhatistheoutcomeifOracleestimatesthattheexecutiontimeforthisoperationwillexceed600seconds?()
第2题:
The Database Resource Manager is not currently active in your database that is up and running. You created a resource plan named DAY_PLAN that contains two sub-plans named MANAGERS_PLAN and CLERKS_PLAN. You decided to activate DAY_PLAN by executing the following statement: SQL>ALTER SYSTEM SET RESOURCE_MANAGER_PLAN = ’managers_plan’; What will be the outcome of this statement?()
第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 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
第4题:
You execute the following block of code: SQL>BEGIN 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?()
第5题:
You recently created a complex resource plan named DB_PLAN that has two subplans named OLTP_PLAN and DSS_PLAN. The OLTP_PLAN and DSS_PLAN subplans are allotted 70 percent and 30 percent of the total CPU resources, respectively. The OLTP_PLAN subplan allocates 35 percent of the available CPU resources to a resource consumer group named ACCT_CLERKS. According to the OLTP_PLAN subplan, the remaining 65 percent of the available CPU resources is allocated to a second resource consumer group named MKT_CLERKS. The CPU resources available to the DSS_PLAN subplan are divided into two resource consumer groups named MKT_MANAGERS and FIN_MANAGERS. The MKT_MANAGERS group receives 65 percent of the available CPU resources, and the FIN_MANAGERS group receives 35 percent of the available CPU resources. What percentage of actual CPU resources will the resource consumer group, MKT_CLERKS, receive, if the DSS_PLAN subplan does NOT consume any CPU resources?()
第6题:
You create two resource plans, one for data warehouse loading jobs at night and the other for application jobs at day time. You want the resource plans to activate automatically so that the resource allocation is optimum as desired by the activity.How would you achieve this?()
第7题:
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?()
第8题:
Youhavecreatedaresourceplan,DAY.Youexecutethefollowingcode:
SQL>BEGIN
DBMS_RESOURCE_MANAGER.CREATE_SIMPLE_DIRECTIVE
(PLAN=>’DAY’,
COMMENT=>’DEPARTMENTSPLAN’,
GROUP_OR_SUBPLAN=>’DEPARTMENTS’,
CPU_P1=0);
END;
Then,youissuethefollowingcode:
SQL>BEGIN
DBMS_RESOURCE_MANAGER.CREATE_SIMPLE_DIRECTIVE
(PLAN=>’DAY’,
COMMENT=>’DEPARTMENTSPLAN’,
GROUP_OR_SUBPLAN=>’DEVELOPERS’,
CPU_P2=100);
END;
Whatwillbetheimpactofexecutingtheabovecode?()
第9题:
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: SQL>EXEC 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?()
第10题:
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: SQL>EXEC 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?()