单项选择题

You have created a resource plan， DAY. You execute the ……

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.

<上一题目录下一题>

热门试题

单项选择题Youarecreatingaresourceconsumergroupusingthe DBMS_RESOURCE_MANAGER.CREATE_CONSUMER_GROUPprocedure.Whichparameterwillyouusetodefinetheresourceschedulingmethodusedbetweensessionswithintheresourcegroup？（）

A. CPU_MTH
B. NEW_CPU_MTH
C. CPU_P1
D. CPU_P2

多项选择题YousettheundopoolresourceplandirectivefortheconsumergroupnamedDSS_USERSthatisassignedtotheDAY_SHIFTplan.Thedatabaseusers，SCOTTandBLAKE，belongtotheDSS_USERSresourcegroup.Theuser，SCOTT，initiatesadatabasesessionandexecutesabatchoperationthatinsertsmillionsofrowsintotheHISTORYtable.WhichtwooptionsaretrueifthetotalundospaceallocatedtotheDSS_USERSgroupexceedsthevaluespecifiedintheundopoolresourceplandirective？（）

A. The batch operation started by the user， SCOTT， terminates with an error.
B. The batch operation started by the user， SCOTT， hangs and you are required to increase the undo pool resource plan directive.
C. The batch operation started by the user， SCOTT， runs uninterrupted because the database uses the SYSTEM tablespace for the undo operation.
D. The user， BLAKE， cannot start a transaction that uses any DML operations until you increase the value of the undo pool resource plan directive.
E. The user BLAKE can start a transaction that uses any DML operations after the batch operation started by the user， SCOTT， terminates with an error.

单项选择题YouarecreatingthesimpleresourceplanusingtheDBMS_RESOURCE_MANAGER.CREATE_SIMPLE_PLANprocedure.Whichresourceallocationpolicywillbeusedfortheresourceplan？（）

A. RATIO
B. EMPHASIS
C. ACTIVE_SESS_POOL_MTH
D. RESOURCE_DEGREE_LIMIT_ABSOLUTE

单项选择题You issued the following block of code： SQL>BEGIN DBMS_RESOURCE_MANAGER_PRIVS.GRANT_SWITCH_CONSUMER_GROUP（ ’PROG_ROLE’， ’DEVELOPERS’ ，FALSE）； END； SQL> Which option is NOT a result of executing the above code？（）

A. The switch privilege is granted to the PROG_ROLE role.
B. The users granted the role PROG_ROLE will be able to switch to the DEVELOPERS group.
C. The users cannot grant the switch privilege to other users.
D. The above code will not be executed successfully because the GRANT_SWITCH_CONSUMER_GROUP procedure is an invalid procedure in Oracle10g.

单项选择题You want to enable the user， Scott， to change to the GRP1 consumer group by issuing the following code： SQL> EXEC DBMS_SESSION.SWITCH_CURRENT_CONSUMER_GROUP （’SCOTT’， ’GRP1’， FALSE）； How will you grant the switch privilege to the user， Scott？（）

A. by using the DBMS_SESSION package
B. by granting the DBA role
C. by using the DBMS_RESOURCE_MANAGER package
D. by using the DBMS_RESOURCE_MANAGER_PRIVS package