View the Exhibit and examine the steps that you executed to create a database resource plan. Subsequently, you execute the following procedure which results in an error:SQL> EXECUTE dbms_resources_manager.validate_pending_area ( );What could be the reason

题目

View the Exhibit and examine the steps that you executed to create a database resource plan. Subsequently, you execute the following procedure which results in an error:SQL> EXECUTE dbms_resources_manager.validate_pending_area ( );What could be the reason?（）

A. The pending area is automatically submitted after the plan creation

B. The procedure must be executed before creating the resources plan directive

C. The SYS_GROUP resource consumer group is not included in the resource plan directive

D. The OTHER_GROUPS resources consumer group is not included in the resource plan directive

相似考题

1.当函数deferDemo返回失败时，并不能destroy已create成功的资源()func deferDemo() error {err := createResource1()if err != nil { return ERR_CREATE_RESOURCE1_FAILED}defer func() { if err != nil { destroyResource1() }}()err = createResource2()if err != nil { return ERR_CREATE_RESOURCE2_FAILED}defer func() { if err != nil { destroyResource2() }}()err = createResource3()if err != nil { return ERR_CREATE_RESOURCE3_FAILED}return nil }此题为判断题(对，错)。

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

3.WhichDBMS_RESOURCE_MANAGERprocedureprioritizesconsumer－groupmappings?()A.CREATE_MAPPING_PRIORITYB.SET_MAPPING_PRIORITYC.SET_MAPPING_ORDERD.PRIORITIZE_MAPPING_ORDERE.ThisfunctionalityisnotavailablethroughtheDBMS_RESOURCE_MANAGERpackage.

4.Youwanttocreateaconsumergroup，GROUP1，andyouexecutethefollowingcommandinthecommandlineinterface：SQL>EXECDBMS_RESOURCE_MANAGER.CREATE_CONSUMER_GROUP（CONSUMER_GROUP=>’group1’，COMMENT=>’NewGroup’）Thiscommanderrorsoutdisplayingthefollowingmessage：ERRORatline1：ORA01031：insufficientprivilegesORA06512：at"SYS.DBMS_RMIN"，line115ORA06512：atSYS.DBMS_RESOURCE_MANAGER"，line108ORA06512：atline1Whatactionwouldyoutaketoovercomethiserror？（）A.grantSYSDBAtotheuserB.grantSYSOPERtotheuserC.granttheRESOURCEroletotheuserD.usetheGRANTcommandtogranttheADMINISTER_RESOURCE_MANAGERprivilegetotheuserE.granttheADMINISTER_RESOURCE_MANAGERprivilegetotheuserbyusingthe DBMS_RESOURCE_MANAGER_PRIVSpackage

参考答案和解析
参考答案：D
更多“View the Exhibit and examine the steps that you executed to create a database resource pla ”相关问题

  • 第1题：

    Youarecreatingajobclass.Youhaveissuedthefollowingcommandtocreatethejobclass：SQL>BEGINDBMS_SCHEDULER.CREATE_JOB_CLASS（JOB_CLASS_NAME=>’LOW_PRIORITY_CLASS’，RESOURCE_CONSUMER_GROUP=>’LOW_GROUP’，LOGGING_LEVEL=>DBMS_SCHEDULER.LOGGING_FULL，LOG_HISTORY=>1200，COMMENTS=>’LOWJOBPRIORITYCLASS’）；END；SQL>/Whatwillbetheresultoftheabovecommand？（）

    A.Thecommandwillbeexecutedsuccessfully.

    B.ThecommandwillfailbecauseRESOURCE_CONSUMER_GROUPisaninvalidparameterintheDBMS_SCHEDULER.CREATE_JOB_CLASSprocedure.

    C.ThecommandwillfailbecauseLOGGING_LEVELisaninvalidparameterintheDBMS_SCHEDULER.CREATE_JOB_CLASSprocedure.

    D.ThecommandwillfailbecauseLOG_HISTORYisaninvalidparameterintheDBMS_SCHEDULER.CREATE_JOB_CLASSprocedure.

    E.Thecommandwillfailbecause1200isaninvalidvaluefortheLOG_HISTORYparameterintheDBMS_SCHEDULER.CREATE_JOB_CLASSprocedure.


    参考答案：E

  • 第2题：

    Youarecreatingaresourceconsumergroupusingthe DBMS_RESOURCE_MANAGER.CREATE_CONSUMER_GROUPprocedure.Whichparameterwillyouusetodefinetheresourceschedulingmethodusedbetweensessionswithintheresourcegroup？（）

    A.CPU_MTH

    B.NEW_CPU_MTH

    C.CPU_P1

    D.CPU_P2


    参考答案：A

  • 第3题：

    Youwanttocreateaconsumergroup，GROUP1，andyouexecutethefollowingcommandinthecommand-lineinterface：SQL>EXECDBMS_RESOURCE_MANAGER.CREATE_CONSUMER_GROUP（CONSUMER_GROUP=>’group1’，COMMENT=>’NewGroup’）；Thiscommanderrorsoutdisplayingthefollowingmessage：ERRORatline1：ORA-29371：pendingareaisnotactiveORA-06512：at"SYS.DBMS_RMIN"，line115ORA-06512：at"SYS.DBMS_RESOURCE_MANAGER"，line108ORA-06512：atline1Whatactionwouldyoutaketoovercomethiserror？（）

    A.activatethePendingAreabeforecreatingtheconsumergroup

    B.createthePendingAreabeforecreatingtheconsumergroup

    C.increasethesizeofthedatabasebuffercachetoaccommodatethePendingArea

    D.increasethesizeofthesharedpooltoaccommodatethePendingArea

    E.increasethesizeofthelargepooltoaccommodatethePendingArea


    参考答案：B

  • 第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题：

    YouarecreatingthesimpleresourceplanusingtheDBMS_RESOURCE_MANAGER.CREATE_SIMPLE_PLANprocedure.Whichresourceallocationpolicywillbeusedfortheresourceplan?()

    A.RATIO

    B.EMPHASIS

    C.ACTIVE_SESS_POOL_MTH

    D.RESOURCE_DEGREE_LIMIT_ABSOLUTE


    参考答案：B

  • 第6题：

    【单选题】对于建立在数据库上的DDL触发器，常用的激活DDL触发器的事件不包括（）

    A．Create_Table，Alter_Table，Drop_Table

    B．Create_View，Alter_View，Drop_View

    C．Create_Procedure，Alter_Procedure，Drop_Procedure

    D．Rollback


    Rollback

相关内容