RATIO
EMPHASIS
ACTIVE_SESS_POOL_MTH
RESOURCE_DEGREE_LIMIT_ABSOLUTE
第1题：
Youhavecreatedaresourceplan，DB_PLAN，usingDBMS_RESOURCE_MANAGER.CREATE_SIMPLE_PLANandyouwanttoimposearestrictiononutilizationofresourcesbythedatabaseusers.Whichstepmustbeperformedbeforeyoucanstartusingtheresourceplan？（）
A.assignuserstoconsumergroups
B.settheresourceplanfortheinstance
C.configureasimpleresourceplanandspecifyplandirectives
D.configureacomplexresourceplanandspecifyplandirectives
第2题：
Youhavecreatedaresourceplan，DAY.Youexecutethefollowingcode：
SQL>BEGIN
DBMS_RESOURCE_MANAGER.CREATE_SIMPLE_DIRECTIVE
（PLAN=>’DAY’，
COMMENT=>’DEPARTMENTSPLAN’，
GROUP_OR_SUBPLAN=>’DEPARTMENTS’，
CPU_P1=0）；
END；
Then，youissuethefollowingcode：
SQL>BEGIN
DBMS_RESOURCE_MANAGER.CREATE_SIMPLE_DIRECTIVE
（PLAN=>’DAY’，
COMMENT=>’DEPARTMENTSPLAN’，
GROUP_OR_SUBPLAN=>’DEVELOPERS’，
CPU_P2=100）；
END；
Whatwillbetheimpactofexecutingtheabovecode？（）
第3题：
View the Exhibit and examine the steps that you executed to create a database resource plan. Subsequently, you execute the following procedure which results in an error:SQL> EXECUTE dbms_resources_manager.validate_pending_area ( );What could be the reason?（）
A. The pending area is automatically submitted after the plan creation
B. The procedure must be executed before creating the resources plan directive
C. The SYS_GROUP resource consumer group is not included in the resource plan directive
D. The OTHER_GROUPS resources consumer group is not included in the resource plan directive
第4题：
For which two situations would you use functionality provided by the Resource Manager? （）(Choose two.)
第5题：
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？（）
第6题：
A. setting idle timeout limits on resource plans
B. saving storage space by using compressed backup sets
C. creating jobs that will run automatically at a scheduled time
D. assigning priorities to jobs to manage access to system resources
E. creating alerts to perform notification when tablespaces are low on available space resources
第7题：
A. Maximum Undo per consumer group
B. Maximum Idle time
C. Parallel server limit
D. CPU
E. Exadata I/O
F. Local file system I/O
第8题：
A. setting idle timeout limits on resource plans
B. saving storage space by using compressed backup sets
C. creating jobs that will run automatically at a scheduled time
D. assigning priorities to jobs to manage access to system resources
E. creating alerts to perform notification when tablespaces are low on available space resources
第9题：
You are creating a resource consumer group using the DBMS_RESOURCE_MANAGER.CREATE_CONSUMER_GROUP procedure. Which parameter will you use to define the resource scheduling method used between sessions within the resource group？（）
第10题：
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？（）