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’Identifyth

题目

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.

相似考题

1.You want to set the following initialization parameters for your database instance:Identify the statement that correctly describes this setting.()A. The MANDATORY location must be a flash recovery area.B. The optional destinations may not use the flash recovery area.C. This setting is not allowed because the first destination is not set as MANDATORY.D. The online redo log file is not allowed to be overwritten if the archived log cannot be created in the fourth destination.

2.YouareworkingasaDBAonOracleDatabase9i.Youplantoupgradeyour9idatabasetoOracle10g.Tobefamiliarwiththenewdatabasetechnology，youdecidetoinstallOracleDatabase10gonyourworkstationathome.Youcreateageneralpurposedatabase.Aftertheinstallation，youmakethefollowingchangesinyourinitializationparameterfile：LOG_ARCHIVE_DEST_1=’LOCATION=USE_DB_RECOVERY_FILE_DEST’DB_RECOVERY_FILE_DEST=’LOCATION=d：\product\10.1.0\flash_recovery_area’DB_RECOVERY_FILE_DEST_SIZE=10gWherearethearchivedredologsstoredforyourdatabase？（）

3.You want to set the following initialization parameters for your database instance: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/arch MANDATORY‘Identify the statement that correctly describes this setting.（）A. The MANDATORY location must be a flash recovery area.B. The optional destinations may not use the flash recovery area.C. This setting is not allowed because the first destination is not set as MANDATORY.D. The online redo log file is not allowed to be overwritten if the archived log cannot be created in the fourth destination.

4.Whatwillbetheresultofthefollowingconfiguration?()Log_archive_dest_1=location=c:\oracle\arch\mydbLog_archive_dest_2=location=z:\oracle\arch\mydbA.Anerrorwilloccurduringdatabasestartupbecausethesecondparameterisnotvalid.B.Anerrorwilloccurduringdatabasestartupsinceyouaretryingtocreatearchivedredologsintwodifferentlocations.C.ArchivedredologswillbecreatedintwodifferentlocationsbytheARCHprocess.D.ArchivedredologswillbecreatedintwodifferentlocationsbytheLGWRprocess.E.Neitherparametersettingisvalid，sothedatabasewillnotstartup.

参考答案和解析
参考答案：D
相关内容