网友您好， 请在下方输入框内输入要搜索的题目：
题目内容
（请给出正确答案）
Youhavecreatedaresourceplan，DAY.Youexecutethefollowingcode：
SQL>BEGIN
DBMS_RESOURCE_MANAGER.CREATE_SIMPLE_DIRECTIVE
（PLAN=>’DAY’，
COMMENT=>’DEPARTMENTSPLAN’，
GROUP_OR_SUBPLAN=>’DEPARTMENTS’，
CPU_P1=0）；
END；
Then，youissuethefollowingcode：
SQL>BEGIN
DBMS_RESOURCE_MANAGER.CREATE_SIMPLE_DIRECTIVE
（PLAN=>’DAY’，
COMMENT=>’DEPARTMENTSPLAN’，
GROUP_OR_SUBPLAN=>’DEVELOPERS’，
CPU_P2=100）；
END；
Whatwillbetheimpactofexecutingtheabovecode？（）
参考答案
更多 “ 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？（） ” 相关考题
考题
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，DB_PLAN，usingDBMS_RESOURCE_MANAGER.CREATE_SIMPLE_PLANandyouwanttoimposearestrictiononutilizationofresourcesbythedatabaseusers.Whichstepmustbeperformedbeforeyoucanstartusingtheresourceplan？（）A.assignuserstoconsumergroupsB.settheresourceplanfortheinstanceC.configureasimpleresourceplanandspecifyplandirectivesD.configureacomplexresourceplanandspecifyplandirectives
热门标签
最新试卷
