网友您好， 请在下方输入框内输入要搜索的题目：

题目内容 （请给出正确答案）

Youhavecreatedaresourceplan，DB_PLAN，usingDBMS_RESOURCE_MANAGER.CREATE_SIMPLE_PLANandyouwanttoimposearestrictiononutilizationofresourcesbythedatabaseusers.Whichstepmustbeperformedbeforeyoucanstartusingtheresourceplan？（）

A.assignuserstoconsumergroups

B.settheresourceplanfortheinstance

C.configureasimpleresourceplanandspecifyplandirectives

D.configureacomplexresourceplanandspecifyplandirectives

参考答案

更多 “ Youhavecreatedaresourceplan，DB_PLAN，usingDBMS_RESOURCE_MANAGER.CREATE_SIMPLE_PLANandyouwanttoimposearestrictiononutilizationofresourcesbythedatabaseusers.Whichstepmustbeperformedbeforeyoucanstartusingtheresourceplan？（）A.assignuserstoconsumergroupsB.settheresourceplanfortheinstanceC.configureasimpleresourceplanandspecifyplandirectivesD.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？（）
查看答案
热门标签
最新试卷