iostat disk1 1
iostat -d disk1 2
iostat disk2 1
iostat -d disk2 2
第1题：
YouwanttosetthefollowingInitializationparametersforyourdatabaseInstanceLOG_ARCHIVE_DEBT_1=，，LOCATION=/disk1/archLOG_ARCHIVE_DBST_2=，，LOCATION=/disk2/archLOC_ARCHIVBDBST_3=，，LOCATION=/disk3/archLOG_ARCHIVEDBST_=，，LOCATION=/disk3/archIdentifythestatementthatcorrectlydescribesthissetting.（）
A.TheMANDATORYlocationmustbeaflashrecoveryarea.
B.Theoptionaldestinationsmaynotusetheflashrecoveryarea.
C.ThissettingisnotallowedbecausethefirstdestinationisnotsetasMANDATORY.
D.Theonlineredologfileisnotallowedtobeoverwrittenifthearchivedlogcannotbecreatedinthefourthdestination.
第2题：
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’；
第3题：
Youwanttosetthefollowinginitializationparametersforyourdatabaseinstance：LOG_ARCHIVE_DEST_1=’LOCATION=/disk1/arch’LOG_ARCHIVE_DEST_2=’LOCATION=/disk2/arch’LOG_ARCHIVE_DEST_3=’LOACTION=/disk3/arch’LOG_ARCHIVE_DEST_4=’LOCATION=/disk4/archMANDATORY’Identifythestatementthatcorrectlydescribesthissetting.（）
A.TheMANDATORYlocationmustbeaflashrecoveryarea.
B.Theoptionaldestinationsmaynotusetheflashrecoveryarea.
C.ThissettingisnotallowedbecausethefirstdestinationisnotsetasMANDATORY.
D.Theonlineredologfileisnotallowedtobeoverwrittenifthearchivedlogcannotbecreatedinthefourthdestination.
第4题：
All of the following types of statistics are reported by the iostat command tool EXCEPT:（）.
第5题：
A.iostatdisk11
B.iostat-ddisk12
C.iostatdisk21
D.iostat-ddisk22
第6题：
Youhavethefollowingonlineredologconfiguration：GroupMember1’/disk1/oradata/redo01a.log’2’/disk2/oradata/redo02a.log’3’/disk3/oradata/redo03a.log’Youdecidetomultiplextheonlineredologgroupsforrecoveryofredologfilesincaseofanydisaster.WhichtwostatementswillyouNOTissuetomultiplextheonlineredologfiles？（）
A.ALTERDATABASEADDLOGFILEMEMBER’/disk1/oradata/redo01b.log’TOGROUP1；
B.ALTERDATABASEADDLOGFILEMEMBER’/disk2/oradata/redo01b.log’TOGROUP1；
C.ALTERDATABASEADDLOGFILEMEMBER’/disk1/oradata/redo02b.log’TOGROUP2；
D.ALTERDATABASEADDLOGFILEMEMBER’/disk2/oradata/redo02b.log’TOGROUP2；
E.ALTERDATABASEADDLOGFILEMEMBER’/disk1/oradata/redo3b.log’TOGROUP3；
F.ALTERDATABASEADDLOGFILEMEMBER’/disk2/oradata/redo3b.log’TOGROUP3；
第7题：
Inwhichsituationwillyourunthescriptcontainingthefollowingstatement？（）
CREATECONTROLFILEREUSEDATABASESALESNORESETLOGSARCHIVELOG
MAXLOGFILES20
MAXLOGMEMBERS3
MAXDATAFILES30
MAXINSTANCES10
MAXLOGHISTORY1200
LOGFILE
GROUP1（
’/disk1/prod/orders/db/log1a.dbf’，
’/disk2/prod/orders/db/log1b.dbf’
）SIZE100K
GROUP2（
’/disk1/prod/orders/db/log2a.dbf’，
’/disk2/prod/orders/db/log2b.dbf’
）SIZE100K，
DATAFILE
’/disk1/prod/orders/db/database1.dbf’，
’/disk2/prod/orders/db/file1.dbf’；
第8题：
YouhaveconfiguredflashrecoveryareainyourdatabaseandyousetthefollowingInitializationparametersforyourdatabaseinstance：
LOG_ARCHIVE_DEST1=，，LOCATION=/disk1/archMANDATORY’
LOG_ARCHIEVE_DEST2=，，LOCATION=/disk2/arch’
LOG_ARCHIVK_DEST_3=，，LOCATION=/diSk3/arch
LOG_ARCH1VK_DEST_4=’LOCATION=/disk4/arch’
LOG_ARCHIVE_MIN-SUCCEED_DEST=2
Whilethedatabaseinstanceisfunctional，yourealizedthatthedestinationsetbythe
LOG_ARCHIVE_DEST_IparameterIsnotavailableforthearchivedredologfiletobecreatedin.Allredologgroupshavebeenused.
Whathappensinaneventoflogswitch？（）
第9题：
A.添加一个磁盘，创建一个新的RAID-5卷
B.用disk1和disk2创建一个带区卷
C.用disk1和disk2创建一个镜像卷
D.用disk1和disk2创建一个跨区卷
第10题：
Examine the RMAN command： SWITCH DATAFILE ’/DISK3/user_data01.dbf’； Which command do you need to issue before you issue the above command， so that RMAN finds the file in the restored location of ’DISK2/user_data01.dbf’？ （）