多选题You set the undo pool resource plan directive for the consumer group named DSS_USERS that is assigned to the DAY_SHIFT plan. The database users， SCOTT and BLAKE， belong to the DSS_USERS resource group. The user， SCOTT， initiates a database session and 

第1题：

第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？（）  

• A、 The statement will deactivate DAY_PLAN.
• B、 The statement will activate DAY_PLAN as the top plan.
• C、 The statement will activate MANAGERS_PLAN as the top plan.
• D、 The statement will return an error because MANAGERS_PLAN is not the top plan.

第3题：

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？（）  

• 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.

第4题：

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？（）  

• 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.

第5题：

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.

第6题：

You set the undo pool resource plan directive for the consumer group named DSS_USERS that is assigned to the DAY_SHIFT plan. The database users， SCOTT and BLAKE， belong to the DSS_USERS resource group. The user， SCOTT， initiates a database session and executes a batch operation that inserts millions of rows into the HISTORY table. Which two options are true if the total undo space allocated to the DSS_USERS group exceeds the value specified in the undo pool resource plan directive？（）

• A、 The batch operation started by the user， SCOTT， terminates with an error.
• B、 The batch operation started by the user， SCOTT， hangs and you are required to increase the undo pool resource plan directive.
• C、 The batch operation started by the user， SCOTT， runs uninterrupted because the database uses the SYSTEM tablespace for the undo operation.
• D、 The user， BLAKE， cannot start a transaction that uses any DML operations until you increase the value of the undo pool resource plan directive.
• E、 The user BLAKE can start a transaction that uses any DML operations after the batch operation started by the user， SCOTT， terminates with an error.

第7题：

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 package
• B、 by granting the DBA role
• C、 by using the DBMS_RESOURCE_MANAGER package
• D、 by using the DBMS_RESOURCE_MANAGER_PRIVS package

第8题：

第9题：

第10题：

第11题：

第12题：

第13题：

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$SYSSTAT
• B、 V$SESSSTAT
• C、 V$RSRC_PLAN
• D、 V$RSRC_CONSUMER_GROUP

第14题：

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 groups
• B、set the resource plan for the instance
• C、configure a simple resource plan and specify plan directives
• D、configure a complex resource plan and specify plan directives

第15题：

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？（）

• 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.

第16题：

From the V$SESSION_LONGOPS view， you find that some of the database users have long-running 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_GROUP
• B、create the pending area for the consumer group
• C、activate the provided SYSTEM_PLAN in Resource Manager
• D、set the TIMED_STATISTICS parameter to TRUE in the parameter file
• E、set the execution time limit for all users， except SYS and SYSTEM， in their profiles

第17题：

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.

第18题：

In your production database， you have multiple resource plan directives that refer to the consumer group DB_GRP. Which two statements are correct？（）

• A、The parallel degree limit for DB_GRP will be the minimum of all the incoming values.
• B、The parallel degree limit for DB_GRP will be the maximum of all the incoming values.
• C、The maximum estimated execution time for DB_GRP would be the most nonrestrictive of all incoming values.
• D、If 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.
• E、If 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.

第19题：

第20题：

第21题：

第22题：

第23题：

第24题：