Youhavecreatedaresourceplan，DB_PLAN，usingDBMS_RESOURCE_MANAGER.CREATE_SIMPLE_PLANandyouwanttoimposearestrictiononutilizationofresourcesbythedatabaseusers.Whichstepmustbeperformedbeforeyoucanstartusingtheresourceplan？（）A.assignuserstoconsumergroupsB.settheresourceplanfortheinstanceC.configureasimpleresourceplanandspecifyplandirectivesD.configureacomplexresourceplanandspecifyplandirectives
Youhavecreatedaresourceplan，DB_PLAN，usingDBMS_RESOURCE_MANAGER.CREATE_SIMPLE_PLANandyouwanttoimposearestrictiononutilizationofresourcesbythedatabaseusers.Whichstepmustbeperformedbeforeyoucanstartusingtheresourceplan？（）
A.assignuserstoconsumergroups
B.settheresourceplanfortheinstance
C.configureasimpleresourceplanandspecifyplandirectives
D.configureacomplexresourceplanandspecifyplandirectives
相关考题：
Youhavecreatedaresourceplan，PROD_DB_PLAN，withthefollowingconsumergroupswiththerespectiveplandirectives：ConsumergroupSALESwithCPU_P1as60andDEGREE_OF_PARALLELISMas4.ConsumergroupMARKETwithCPU_P1as20.ConsumergroupDEVwithCPU_P1as20.ConsumergroupOTHERSwithCPU_P1as0andCPU_P2as100.Whichtwostatementsarecorrectinthisscenario？（）A.Themaximumdegreeofparallelismforthemembersoftheconsumergroupsis4.B.TheCPUallocationwillalwaysbeequalfortheconsumergroupsMARKETandDEV.C.TheOTHERSconsumergroupwouldget100%oftheCPUifthereareunusedlevel1CPUresources.D.TheSALESandMARKETconsumergroupswouldget100%oftheCPUifthereareunusedlevel2CPUresources.E.ThemaximumdegreeofparallelismforthemembersoftheconsumergroupSALESis4withnorestrictionfortheremaininggroups.
Youhavecreatedaresourceplan，PROD_DB_PLAN，thatusestheRATIOpolicy.Thefollowingconsumergroupsandtheirrespectiveplandirectiveshavebeenassignedtothisresourceplan：ConsumergroupHIGH_CGwithCPU_P1as10.ConsumergroupMEDIUM_CGwithCPU_P1as5.ConsumergroupLOW_CGwithCPU_P1as2.ConsumergroupOTHER_GROUPSwithCPU_P1as1.Whichstatementiscorrectinthisscenario？（）A.TheplanPROD_DB_PLANcanhavesubplans.B.ThemembersoftheHIGH_CGconsumergroupwouldget10%oftheCPU.C.TheCPUallocationfortheconsumergroupswouldbebasedontheratiodefinedfortheCPU_P1.D.TheCPUallocationwouldbeequalbetweentheHIGH_CGandMEDIUM_CGconsumergroupsiftherearenosessionsexistingfortheLOW_CGandOTHER_GROUPSconsumergroups.
Youhavecreatedaresourceplan，DAY.Youexecutethefollowingcode：SQLBEGINDBMS_RESOURCE_MANAGER.CREATE_SIMPLE_DIRECTIVE（PLAN=’DAY’，COMMENT=’DEPARTMENTSPLAN’，GROUP_OR_SUBPLAN=’DEPARTMENTS’，CPU_P1=0）；END；Then，youissuethefollowingcode：SQLBEGINDBMS_RESOURCE_MANAGER.CREATE_SIMPLE_DIRECTIVE（PLAN=’DAY’，COMMENT=’DEPARTMENTSPLAN’，GROUP_OR_SUBPLAN=’DEVELOPERS’，CPU_P2=100）；END；Whatwillbetheimpactofexecutingtheabovecode？（）