单项选择题 YourecentlycreatedacomplexresourceplannamedDB_PLANthathastwosubplansnamedOLTP_PLANandDSS_PLAN.TheOLTP_PLANandDSS_PLANsubplansareallotted70percentand30percentofthetotalCPUresources，respectively.TheOLTP_PLANsubplanallocates35percentoftheavailableCPUresourcestoaresourceconsumergroupnamedACCT_CLERKS.Accordingtothe OLTP_PLANsubplan，theremaining65percentoftheavailableCPUresourcesisallocatedtoasecondresourceconsumergroupnamedMKT_CLERKS.TheCPUresourcesavailabletotheDSS_PLANsubplanaredividedintotworesourceconsumergroupsnamedMKT_MANAGERSandFIN_MANAGERS.TheMKT_MANAGERSgroupreceives65percentoftheavailableCPUresources，andtheFIN_MANAGERSgroupreceives35percentoftheavailableCPUresources.WhatpercentageofactualCPUresourceswilltheresourceconsumergroup，MKT_CLERKS，receive，iftheDSS_PLANsubplandoesNOTconsumeanyCPUresources？（）

单项选择题 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？（）

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