Youhaveadiskgroup，DGROUP1，withthreediskandNORMALredundancy.Youexecutethefollowingcommandtocreateatemplateforthediskgroup：ALTERDISKGROUPdgroup1ADDTEMPLATEmy_tempATTRIBUTES（MIRRORFINE）；Whichstatementistrue？（）A.WhenafileiscreatedinDGROUP1withthetemplate，itwouldhavethree-waymirroring.B.WhenafileiscreatedinDGROUP1，theMY_TEMPtemplatebecomesthedefaulttemplate.C.WhenafileiscreatedinDGROUP1withthetemplate，itwouldhavetwo-waymirroringandfilestriping.D.WhenafileiscreatedinDGROUP1withthetemplate，itwouldhavethree-waymirroringandfilestriping.E.WhenafileiscreatedinDGROUP1withthetemplate，itwouldhavetwo-waymirroringbutnofilestriping.
Youhaveadiskgroup，DGROUP1，withthreediskandNORMALredundancy.Youexecutethefollowingcommandtocreateatemplateforthediskgroup：ALTERDISKGROUPdgroup1ADDTEMPLATEmy_tempATTRIBUTES（MIRRORFINE）；Whichstatementistrue？（）
A.WhenafileiscreatedinDGROUP1withthetemplate，itwouldhavethree-waymirroring.
B.WhenafileiscreatedinDGROUP1，theMY_TEMPtemplatebecomesthedefaulttemplate.
C.WhenafileiscreatedinDGROUP1withthetemplate，itwouldhavetwo-waymirroringandfilestriping.
D.WhenafileiscreatedinDGROUP1withthetemplate，itwouldhavethree-waymirroringandfilestriping.
E.WhenafileiscreatedinDGROUP1withthetemplate，itwouldhavetwo-waymirroringbutnofilestriping.
相关考题：
A database instance is using an Automatic Storage Management (ASM) instance, which has a disk group, DGROUP1, created as follows:What happens when the whole CONTROLLER1 Failure group is damaged?() A. The transactions that use the disk group will halt.B. The mirroring of allocation units occurs within the CONTROLLER2 failure group.C. The data in the CONTROLLER1 failure group is shifted to the CONTROLLER2 failure group and implicit rebalancing is triggered.D. The ASM does not mirror any data and newly allocated primary allocation units (AU) are stored in the CONTROLLER2 failure group.
AstheDBA，yourunthefollowingqueryonyourASMinstance.Whatistheimplicationoftheresultsofthequery？（）SQLselectgroup_number，name，statefromv$ASM_DISKGROUP；GROUP_NUMBERNAMESTATE0DGROUP1DISMOUNTED2DGROUP2MOUNTED3DGROUP3MOUNTEDA.TheDGROUP1diskgroupwasunmountedbyanotherDBA.B.Adatafilehasbeenlost，causingtheASMdiskgroupDGROUP1togointotheDISMOUNTEDstateC.Oneoftheredundantdisks（DGROUP1）hasbeenlostinadiskgroup.D.ThisqueryhasnomeaninginanASMinstance.E.AdiskassociatedwithadiskgroupwasdiscoveredaftertheASMinstanceinitiallyopened.
Youhaveadiskgroup，DGROUP1，withthreedisksandNORMALredundancy.Youexecutethefollowingcommandtocreateatemplateforthediskgroup：ALTERDISKGROUPdgroup1ADDTEMPLATEmy_tempATTRIBUTES（MIRRORFINE）Whichstatementistrue？（）A.WhenafileiscreatedinDGROUP1withthetemplate，itwouldhavethreewaymirroring.B.WhenafileiscreatedinDGROUP1，theMY_TEMPtemplatebecomesthedefaulttemplate.C.WhenafileiscreatedinDGROUP1withthetemplate，itwouldhavetwowaymirroringandfilestriping.D.WhenafileiscreatedinDGROUP1withthetemplate，itwouldhavethreewaymirroringandfilestriping.E.WhenafileiscreatedinDGROUP1withthetemplate，itwouldhavetwowaymirroringbutnofilestriping.
InyourAutomaticStorageManagement（ASM）instance，oneofthenonemptydiskgroups，DGROUP1，isnolongerrequiredandyouwantthisdiskgrouptoberemoved.Youexecutethefollowingcommandtoachievethisobjective：DROPDISKGROUPdgroup1EXCLUDINGCONTENTS；Whatwouldbetheresultofthiscommand？（）A.Thiscommandwouldresultinanerrorbecausethediskgroupisnotempty.B.Thecommandwoulddropthediskgroup，ignoringtheEXCLUDINGCONTENTSoption.C.ThecommandwouldresultinthediskgroupbeingmarkedasINVALIDbecauseitcannotbedropped.D.Thecommandwouldresultinthecontentsbeingmovedtotheparentdiskgroupanddroppingofthediskgroup.E.Thecommandwoulddistributethecontentsofthespecifieddiskgroupamongallotherdiskgroupsandthendropthespecifieddiskgroup.
作为一个oracleDBA,你运行以下的SQL命令查询ASM实例,查询结果的含义是什么?()SQL>select group_number,name,state from v$ASM_DISKGROUP;GROUP_NUMBER NAME STATE 0 DGROUP1DISMOUNTED2 DGROUP2 MOUNTED3 DGROUP3 MOUNTED A.这个查询在ASM实例中没有意义B.一个多余的磁盘(DGROUP1)将在磁盘组中丢失C.一个数据文件丢失，原因是DGROUP1磁盘组正在进入DISMOUNTED状态D.DGROUP1磁盘组被其他的DBA卸载了