Which three resources might be prioritized between competing pluggable databases when creating amultitenant container database plan (CDB plan) using Oracle Database Resource Manager?() A. Maximum Undo per consumer groupB. Maximum Idle timeC. Parallel server limitD. CPUE. Exadata I/OF. Local file system I/O
Which three resources might be prioritized between competing pluggable databases when creating amultitenant container database plan (CDB plan) using Oracle Database Resource Manager?()
A. Maximum Undo per consumer group
B. Maximum Idle time
C. Parallel server limit
D. CPU
E. Exadata I/O
F. Local file system I/O
相关考题：
Youexecutethefollowingcommandtocreatetwoconsumergroups，FIN_GROUP1andPAY_GROUP1，foraplan，PROD_PLAN：BEGINDBMS_RESOURCE_MANAGER.CREATE_SIMPLE_PLAN（SIMPLE_PLAN=’prod_plan’，CONSUMER_GROUP1=’fin_group1’，GROUP1_CPU=80，CONSUMER_GROUP2=’pay_group1’，GROUP2_CPU=20）ENDWhichthreestatementsaretrue？（）A.SYS_GROUPgets100%CPUresourcesatlevel1.B.FIN_GROUP1gets80%CPUresourcesatlevel1.C.FIN_GROUP1gets80%CPUresourcesatlevel2.D.PAY_GROUP1gets20%CPUresourcesatlevel1.E.PAY_GROUP1gets20%CPUresourcesatlevel2.F.OTHER_GROUPgets100%CPUresourcesatlevel1.G.OTHER_GROUPgets100%CPUresourcesatlevel2.
Youhavecreatedaresourceplan，DB_PLAN，usingDBMS_RESOURCE_MANAGER.CREATE_SIMPLE_PLANandyouwanttoimposearestrictiononutilizationofresourcesbythedatabaseusers.Whichstepmustbeperformedbeforeyoucanstartusingtheresourceplan？（）A.assignuserstoconsumergroupsB.settheresourceplanfortheinstanceC.configureasimpleresourceplanandspecifyplandirectivesD.configureacomplexresourceplanandspecifyplandirectives
Youhavecreatedascriptintherecoverycatalogcalledbackup_database.Whichofthefollowingcommandswouldsuccessfullyexecutethatscript?() A.run{openscriptbackup_database；runscriptbackup_database}B.run{engagescriptbackup_database；}C.run{runscriptbackup_database；}D.Run{executescriptbackup_database；}E.Thenamebackup_databaseisaninvalidnameforanRMANscript.TryingtorunitfromRMAN wouldresultinanerror.
Youexecutethefollowingblockofcode：SQLBEGINDBMS_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/Whatisaprerequisiteforusingthesimpleresourceplancreatedbyexecutingtheabovecode？（）A.Youmustassignuserstoconsumergroups.B.Youmustgranttheswitchprivilegetotheusers.C.Youmustcreatearesourceplandirective.D.Youmustspecifythecomplexresourceplan.
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？（）
Youupdatedtheresourceplandirectivefortheresourceconsumergroup，DSS_USERS.TheresourceplandirectiveisassignedtotheDSS_PLANbyusingthefollowingstatement：SQLEXECDBMS_RESOURCE_MANAGER.UPDATE_PLAN_DIRECTIVE（PLAN=’DSS_PLAN’，GROUP_OR_SUBPLAN=’DSS_USERS’，NEW_CPU_P1=80，NEW_SWITCH_GROUP=’CANCEL_SQL’，NEW_SWITCH_ESTIMATE=TRUE，NEW_SWITCH_TIME=600）；Auserconnectstothedatabaseandstartsanoperation.WhatistheoutcomeifOracleestimatesthattheexecutiontimeforthisoperationwillexceed600seconds？（）
TheDatabaseResourceManagerisnotcurrentlyactiveinyourdatabasethatisupandrunning.YoucreatedaresourceplannamedDAY_PLANthatcontainstwosub-plansnamedMANAGERS_PLANandCLERKS_PLAN.YoudecidedtoactivateDAY_PLANbyexecutingthefollowingstatement：SQL>ALTERSYSTEMSETRESOURCE_MANAGER_PLAN=’managers_plan’；Whatwillbetheoutcomeofthisstatement？（）A.ThestatementwilldeactivateDAY_PLAN.B.ThestatementwillactivateDAY_PLANasthetopplan.C.ThestatementwillactivateMANAGERS_PLANasthetopplan.D.ThestatementwillreturnanerrorbecauseMANAGERS_PLANisnotthetopplan.
YouareusingtheDatabaseResourceManagertomanagedatabaseresources.YoucreatedaresourceplandirectivefortheMANAGERSresourceconsumergroupundertheSALES_PLANbyusingthefollowingstatement：SQLEXECDBMS_RESOURCE_MANAGER.CREATE_PLAN_DIRECTIVE（PLAN=’SALES_PLAN’，GROUP_OR_SUBPLAN=’MANAGERS’，CPU_P1=100，CPU_P2=0，SWITCH_GROUP=’CLERKS’，SWITCH_TIME_IN_CALL=600）；Auser，SCOTT，whoisassignedtotheMANAGERSgroup，startsadatabasesessionandexecutesaqueryonthedatabase.Whatistheoutcomeifthequerytakesapproximately15minutestocomplete？（）
Youexecutethefollowingcommandtocreatetwoconsumergroups，FIN_GROUP1andPAY_GROUP1foraplan，PROD_PLAN：BEGINDBMS_RESOURCE_MANAGER.CREATE_SIMPLE_PLAN（SIMPLE_PLAN=’prod_plan’，CONSUMER_GROUP1=’fin_group1’，GROUP1_CPU=80，CONSUMER_GROUP2=’pay_group1’，GROUP2_CPU=20）；END；Whichthreestatementsaretrue？（）A.SYS_GROUPgets100%CPUresourcesatlevel1.B.FIN_GROUP1gets80%CPUresourcesatlevel1.C.FIN_GROUP1gets80%CPUresourcesatlevel2.D.PAY_GROUP1gets20%CPUresourcesatlevel1.E.PAY_GROUP1gets20%CPUresourcesatlevel2.F.OTHER_GROUPgets100%CPUresourcesatlevel1.G.OTHER_GROUPgets100%CPUresourcesatlevel2.