You execute the following command to create two consumer groups， FIN_GROUP1 and PAY_GROUP1， for a plan，PROD_PLAN：  BEGIN  DBMS_RESOURCE_MANAGER.CREATE_SIMPLE_PLAN （SIMPLE_PLAN = ’prod_plan’，  CONSUMER_GROUP1 = ’fin_group1’，  GROUP1_CPU = 80，  CONSUMER_GRO

第1题：

第2题：

You are creating a Web-based application to manage data aggregation for reports. The application connects to a SQL Server 2005 database named DataManager. One page in the application has controls that execute stored procedures in a database named ReportingDatabase. There is an existing Service Broker connection between the DataManager database and ReportingDatabase.You want to add two new message types to the existing service. In each database， you create message types named ProcessReport and SendResult. You need to add the two new message types to the existing service. What should you do first？（）

• A、Create a queue on each database with the ACTIVATION argument set to DataManager dbo processReport.
• B、Create a conversation between the databases by using the following Statement BEGIN DIALOG FROM SERVICE ’ProcessReport’ TO SERVICE ’SendResult’
• C、Create a contract between the services by using the following statement.CREATE CONTRACT processData （ProcessReport SENT BY INITIATOR，SendResult SENT BY TARGET）
• D、Create services for each database by using the following statement.CREATE SERVICE DataManager on QUEUE ProcessReport

第3题：

第4题：

You plan to execute the following command to perform a Flashback Database operation in your database：   SQL> FLASHBACK DATABASE TO TIMESTAMP （SYSDATE -5/24）；   Which two statements are true about this？（）

• A、 The database must have multiplexed redo log files
• B、 The database must be in the MOUNT state to execute the command
• C、 The database must be in the NOMOUNT state to execute the command
• D、 The database must be opened in RESTRICTED mode before this operation
• E、 The database must be opened with the RESETLOGS option after the flashback operation

第5题：

What must an administrator do to create two new volume groups on a system with only one spare disk?（）

• A、Run the 'mkvg -M' command to create multiple volume groups on a single disk
• B、Add a new disk to the system or release a disk from the one of the existing volume groups
• C、Run the 'mkvg' command to create multiple volume groups on a single disk providing the disk does not have a PVID
• D、Run the 'mkvg' command to create multiple volume groups on a single disk providing the volume groups have the same PP size

第6题：

第7题：

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.

第8题：

第9题：

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.

第10题：

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