Examine the CREATE DISKGROUP command used to create a disk group:In which situation would you use this method of disk group creation?()A. When two-way disk mirroring is required for the allocation unitsB. When three-way disk mirroring is required for the

题目
Examine the CREATE DISKGROUP command used to create a disk group:In which situation would you use this method of disk group creation?()

A. When two-way disk mirroring is required for the allocation units

B. When three-way disk mirroring is required for the allocation units

C. When using hardware mirroring or RAID

D. When disk mirroring is required for the Automatic Storage Management (ASM) disks

相似考题

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

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

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

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.

更多“Examine the CREATE DISKGROUP command used to create a disk group:In which situation would you use this method of disk group creation?() ”相关问题

  • 第1题：

    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

  • 第2题：

    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

  • 第3题：

    YouarecreatinganewformfortheOrderEntryapplication.Youdefinearecordgroupthatwillbecreatedwhentheformisexecutingthisbuiltin:CREATE_GROUP(rg_emplist,global_scope)Whichform(s)intheapplicationwillhaveaccesstothisrecordgroup?（）

    A.Allformsintheapplication.

    B.Anyformsopenedbytheuserwhoinitiatedtherecordgroup.

    C.OnlytheformissuingtheCREATE_GROUPbuilt-in.

    D.Anyformsreferencedbytheformthatcontainstheprocedure.


    参考答案：A

  • 第4题：

    YouareworkingasaDBAinanorganization.Theflashrecoveryareafilesarecreatedin’+disk1’.Youwanttocreatenewflashrecoveryareafilesinthe’+disk2’location.Thenewlocationoftheflashrecoveryareafilesshouldbewritteninthecontrolfileandthespfile.Whichcommandwillyouissuetochangethelocationoftheflashrecoveryareafiles？（）

    A.ALTERSYSTEMSETDB_RECOVERY_FILE_DEST=’+disk2’；

    B.ALTERSYSTEMSETDB_RECOVER_FILE_DEST=’+disk2’SCOPE=BOTH；

    C.ALTERSYSTEMSETDB_CREATE_FILE_DEST=’+disk2’；

    D.ALTERSYSTEMSETDB_CREATE_ONLINE_LOG_DEST_n=’+disk2’；


    参考答案：B

  • 第5题：

    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

  • 第6题：

    Yourapplicationrequiresthatyouprogrammaticallymanipulateanonqueryrecordgroup.Whichthreebuilt－inscanyouuse?()

    A.CREATE_GROUP

    B.ADD_GROUP_NOW

    C.POPULATE_GROUP

    D.ADD_GROUP_COLUMN

    E.CREATE_GROUP_FROM_QUERY


    参考答案：A, B, D

相关内容