单项选择题
A. Only one nested subplan is allowed.
B. The plans can be nested up to four levels.
C. Resource Manager does not support nested plans.
D. Nested plans control only the degree of parallelism but not the CPU.
E. Each nested plan gets a proportion of the CPU resources assigned to its parent group.
多项选择题 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？ （）
单项选择题 Yourbusinesshasdepartmentalreportsthataregeneratedeveryday.Eachdepartmentmustusethesamesetofqueries，butaccessadifferentsubsetofdatainthetables，dependingonwhichdepartmentgeneratesthereport.Theformatofthereportsisbeingdeveloped；currently，theformatchangesdaily.Howwouldyouconfigurethedatabasetoensurethateachdepartmentgeneratesitsreport（basedonitstargetdata）usingthemostrecentreportformateveryday？（）
单项选择题 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？（）