多項(xiàng)選擇題

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_GROUP2 => ’pay_group1’，
GROUP2_CPU => 20）；
END；
Which three statements are true？（）

A. SYS_GROUP gets 100% CPU resources at level 1.
B. FIN_GROUP1 gets 80% CPU resources at level 1.
C. FIN_GROUP1 gets 80% CPU resources at level 2.
D. PAY_GROUP1 gets 20% CPU resources at level 1.
E. PAY_GROUP1 gets 20% CPU resources at level 2.
F. OTHER_GROUP gets 100% CPU resources at level 1.
G. OTHER_GROUP gets 100% CPU resources at level 2.

你可能感興趣的試題

單項(xiàng)選擇題

Your business has departmental reports that are generated every day. Each department must use the same set of queries， but access a different subset of data in the tables， depending on which department generates the report. The format of the reports is being developed； currently， the format changes daily. How would you configure the database to ensure that each department generates its report （based on its target data） using the most recent report format every day？（）

A. By having each user run the report generation procedure at the scheduled time， supplying the necessary input variables.
B. By creating a program using DBMS_JOB that accepts one or more variables， and creating a job that calls this program using DBMS_JOB.
C. By having each user schedule a job using DBMS_JOB that accepts one or more input variables and calls a procedure that generates the report.
D. By having each user create a job using DBMS_SCHEDULER that includes all the information and commands necessary to generate the report.
E. By creating a program using DBMS_SCHEDULER that accepts one or more variables， and creating a job that calls this program using DBMS_SCHEDULER.

單項(xiàng)選擇題

Consider the following command to add a new disk group called "tdgroupA" with two failover groups： CREATE DISKGROUP tdgroupA NORMAL REDUNDANCY FAILOVERGROUP control01 DISK
’/devices/A1’，
’/devices/A2’，
’/devices/A3’
FAILOVERGROUP control02 DISK
’/devices/B1’，
’/devices/B2’，
’/devices/B3’m
The disk "/devices/A1" is currently a member disk of a disk group by the name "tdgroup1".
Which task would be accomplished by the command？（）

A. This command would result in an error because a disk group can have only one failover group.
B. This command would result in an error because the /devices/A1 disk is a member of another disk group tdgroup1.
C. A new disk group called tdgroupA will be added with two failover groups and the /devices/A1 disk will get reattached to the new disk group without being detached from the existing one.
D. A new disk group called tdgroupA will be added with two failover groups and the /devices/A1 disk will be ignored for the new disk group because it is a member of an existing disk group tdgroup1.
E. A new disk group called tdgroupA will be added with two failover groups and the /devices/A1 disk gets detached from the existing disk group tdgroup1 and attached to the new disk group tdgroupA