单选题You have created a resource plan， DAY. You execute the following code：        SQL> BEGIN        DBMS_RESOURCE_MANAGER.CREATE_SIMPLE_DIRECTIVE   （ PLAN => ’DAY’，        COMMENT => ’DEPARTMENTS PLAN’，   GROUP_OR_SUBPLAN => ’DEPARTMENTS’，        CPU_P1=0）

第1题：

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.

第2题：

Using Oracle Scheduler you have scheduled two jobs， JOB_Aand JOB_B， to run at 9：00 p.m. every Friday. You want both the jobs to use a single resource plan， WEEKEND_PLAN. Which task must have already been performed to enable you to achieve this objective？（）

• A、 A window must have been created with the WEEKEND_PLAN resource plan.
• B、 A program must have been created with the WEEKEND_PLAN resource plan.
• C、 A job class must have been created with the WEEKEND_PLAN resource plan.
• D、 A window group must have been created with the WEEKEND_PLAN resource plan.

第3题：

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

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

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

第5题：

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、 RATIO
• B、 EMPHASIS
• C、 ACTIVE_SESS_POOL_MTH
• D、 RESOURCE_DEGREE_LIMIT_ABSOLUTE

第6题：

You work in a company which uses SQL Server 2008. You are the administrator of the company database. Now you are in charge of a SQL Server 2008 instance. There is a database named DB1 in the instance. You put forward a database maintenance plan. The maintenance plan rebuilds indexes, checks database integrity, writes a report to a text file. Now the company requires that when the maintenance plan executes abnormally, the operators can be notified by an e-mail message. You've been assigned this task. So you have to make modifications on the SQL Server instance. What should you do?（）

• A、For the SQL Server Agent, you should enable a fail-safe operator 
• B、You should modify the database maintenance plan, making it send an e-mail to the appropriate operators 
• C、You should modify the database maintenance plan, making it include a Notify Operator task that e-mails the appropriate operators. 
• D、You should modify the SQL Server Agent job. The job executes the database maintenance plan to notify the appropriate operators.

第7题：

第8题：

第9题：

第10题：

第11题：

第12题：

第13题：

You run the SQL Tuning Advisor (STA) to tune a SQL statement that is part of a fixed SQL plan baseline. The STA generates a SQL profile for the SQL statement, which recommends that you accept the profile. Which statement is true when you accept the suggested SQL profile?（）

• A、The tuned plan is not added to the SQL plan baseline.
• B、The tuned plan is added to the fixed SQL plan baseline as a fixed plan.
• C、The tuned plan is added to the fixed SQL plan baseline as a nonfixed plan.
• D、The tuned plan is added to a new nonfixed SQL plan baseline as a nonfixed plan.

第14题：

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.

第15题：

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.

第16题：

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.

第17题：

You have created a resource plan， DAY. You execute the following code：        SQL> BEGIN        DBMS_RESOURCE_MANAGER.CREATE_SIMPLE_DIRECTIVE   （ PLAN => ’DAY’，        COMMENT => ’DEPARTMENTS PLAN’，   GROUP_OR_SUBPLAN => ’DEPARTMENTS’，        CPU_P1=0）；        END；   Then， you issue the following code：        SQL> BEGIN   DBMS_RESOURCE_MANAGER.CREATE_SIMPLE_DIRECTIVE        （ PLAN => ’DAY’，        COMMENT => ’DEPARTMENTS PLAN’，        GROUP_OR_SUBPLAN => ’DEVELOPERS’，        CPU_P2=100）；        END；   What will be the impact of executing the above code？（）  

• A、 The DEVELOPERS and DEPARTMENTS subplans will be allocated CPU equally.
• B、 The DEVELOPERS subplan will be allocated 100 percent CPU if there are no resources allocated to the DEPARTMENTS subplan.
• C、 The DEPARTMENT subplan will be allocated 100 percent CPU if there are no resources allocated to the DEVELOPERS subplan.
• D、 The second code will not execute because one resource plan cannot be used by more than one subplan.

第18题：

第19题：

第20题：

第21题：

第22题：

第23题：

第24题：