网友您好， 请在下方输入框内输入要搜索的题目：
题目内容
（请给出正确答案）
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
参考答案
更多 “ 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 allocation unitsC. When using hardware mirroring or RAIDD. When disk mirroring is required for the Automatic Storage Management (ASM) disks ” 相关考题
考题
Youwanttocreateaconsumergroup，GROUP1，andyouexecutethefollowingcommandinthecommandlineinterface：SQLEXECDBMS_RESOURCE_MANAGER.CREATE_CONSUMER_GROUP（CONSUMER_GROUP=’group1’，COMMENT=’NewGroup’）Thiscommanderrorsoutdisplayingthefollowingmessage：ERRORatline1：ORA01031：insufficientprivilegesORA06512：atSYS.DBMS_RMIN，line115ORA06512：atSYS.DBMS_RESOURCE_MANAGER，line108ORA06512：atline1Whatactionwouldyoutaketoovercomethiserror？（）A.grantSYSDBAtotheuserB.grantSYSOPERtotheuserC.granttheRESOURCEroletotheuserD.usetheGRANTcommandtogranttheADMINISTER_RESOURCE_MANAGERprivilegetotheuserE.granttheADMINISTER_RESOURCE_MANAGERprivilegetotheuserbyusingthe DBMS_RESOURCE_MANAGER_PRIVSpackage
考题
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.
考题
Youarecreatingajobclass.Youhaveissuedthefollowingcommandtocreatethejobclass：SQLBEGINDBMS_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.
考题
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？（）
考题
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’；
考题
Youwanttocreateaconsumergroup，GROUP1，andyouexecutethefollowingcommandinthecommand-lineinterface：SQLEXECDBMS_RESOURCE_MANAGER.CREATE_CONSUMER_GROUP（CONSUMER_GROUP=’group1’，COMMENT=’NewGroup’）；Thiscommanderrorsoutdisplayingthefollowingmessage：ERRORatline1：ORA-29371：pendingareaisnotactiveORA-06512：atSYS.DBMS_RMIN，line115ORA-06512：atSYS.DBMS_RESOURCE_MANAGER，line108ORA-06512：atline1Whatactionwouldyoutaketoovercomethiserror？（）A.activatethePendingAreabeforecreatingtheconsumergroupB.createthePendingAreabeforecreatingtheconsumergroupC.increasethesizeofthedatabasebuffercachetoaccommodatethePendingAreaD.increasethesizeofthesharedpooltoaccommodatethePendingAreaE.increasethesizeofthelargepooltoaccommodatethePendingArea
考题
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.
考题
YouarecreatinganewformfortheOrderEntryapplication.Youdefinearecordgroupthatwillbecreatedwhentheformisexecutingthisbuiltin:CREATE_GROUP(rg_emplist,global_scope)Whichform(s)intheapplicationwillhaveaccesstothisrecordgroup?（）A.Allformsintheapplication.B.Anyformsopenedbytheuserwhoinitiatedtherecordgroup.C.OnlytheformissuingtheCREATE_GROUPbuilt-in.D.Anyformsreferencedbytheformthatcontainstheprocedure.
考题
Yourapplicationrequiresthatyouprogrammaticallymanipulateanonqueryrecordgroup.Whichthreebuilt－inscanyouuse?()
A.CREATE_GROUPB.ADD_GROUP_NOWC.POPULATE_GROUPD.ADD_GROUP_COLUMNE.CREATE_GROUP_FROM_QUERY
热门标签
最新试卷