单项选择题

YourecentlycreatedacomplexresourceplannamedDB_PLANthath……

You recently created a complex resource plan named DB_PLAN that has two subplans named OLTP_PLAN and DSS_PLAN. The OLTP_PLAN and DSS_PLAN subplans are allotted 70 percent and 30 percent of the total CPU resources， respectively. The OLTP_PLAN subplan allocates 35 percent of the available CPU resources to a resource consumer group named ACCT_CLERKS. According to the OLTP_PLAN subplan， the remaining 65 percent of the available CPU resources is allocated to a second resource consumer group named MKT_CLERKS. The CPU resources available to the DSS_PLAN subplan are divided into two resource consumer groups named MKT_MANAGERS and FIN_MANAGERS. The MKT_MANAGERS group receives 65 percent of the available CPU resources， and the FIN_MANAGERS group receives 35 percent of the available CPU resources. What percentage of actual CPU resources will the resource consumer group， MKT_CLERKS， receive， if the DSS_PLAN subplan does NOT consume any CPU resources？（）

A. 45.5
B. 65
C. 70
D. 100

<上一题目录下一题>

热门试题

单项选择题You execute the following block of code： SQL>BEGIN DBMS_RESOURCE_MANAGER.CREATE_SIMPLE_PLAN （ SIMPLE_PLAN => ’DEPARTMENTS’， CONSUMER_GROUP1 => ’PAYROLLL’， GROUP1_CPU => 50， CONSUMER_GROUP2 => ’SALES’， GROUP2_CPU => 25， CONSUMER_GROUP3 => ’MARKETING’， GROUP3_CPU => 25）； END； SQL> What is a prerequisite for using the simple resource plan created by executing the above code？（）

A. You must assign users to consumer groups.
B. You must grant the switch privilege to the users.
C. You must create a resource plan directive.
D. You must specify the complex resource plan.

单项选择题YourecentlyactivatedaresourceplannamedOLTP_PLANinyourdatabase.Severalusersareconcurrentlyrunninglongtransactions.YoudecidetomonitortheresourcemanagertodetermineiftheresourceallocationformulatedintheOLTP_PLANissufficientforpeakdatabasehours.WhichdynamicperformanceviewshouldyouusetodisplaytheCPUtimeconsumedbyallthesessionswithintheresourcegroups？（）

A. V$SYSSTAT
B. V$SESSSTAT
C. V$RSRC_PLAN
D. V$RSRC_CONSUMER_GROUP

单项选择题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.