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 serve

题目
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

相似考题

1.ORACLE9.2.0.1.0数据库中,创建用户的命令是:()A.setupB.createC.establishD.plan

2.Youhavecreatedaresourceplan，DB_PLAN，usingDBMS_RESOURCE_MANAGER.CREATE_SIMPLE_PLANandyouwanttoimposearestrictiononutilizationofresourcesbythedatabaseusers.Whichstepmustbeperformedbeforeyoucanstartusingtheresourceplan？（）A.assignuserstoconsumergroupsB.settheresourceplanfortheinstanceC.configureasimpleresourceplanandspecifyplandirectivesD.configureacomplexresourceplanandspecifyplandirectives

3.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.

4.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.

更多“Which three resources might be prioritized between competing pluggable databases when creating amultitenant container database plan (CDB plan) using Oracle Database Resource Manager?() ”相关问题

  • 第1题：

    Youexecutethefollowingblockofcode：SQL>BEGINDBMS_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.


    参考答案：A

  • 第2题：

    Youupdatedtheresourceplandirectivefortheresourceconsumergroup，DSS_USERS.TheresourceplandirectiveisassignedtotheDSS_PLANbyusingthefollowingstatement：

    SQL>EXECDBMS_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？（）


    参考答案：B

  • 第3题：

    YouareusingtheDatabaseResourceManagertomanagedatabaseresources.YoucreatedaresourceplandirectivefortheMANAGERSresourceconsumergroupundertheSALES_PLANbyusingthefollowingstatement：

    SQL>EXECDBMS_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？（）


    参考答案：D

  • 第4题：

    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？（）


    参考答案：B

  • 第5题：

    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.


    参考答案：C

  • 第6题：

    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.


    参考答案：A, C, E

相关内容