Which three types of files can be automatically placed in the flash recovery area (fast recovery area in 11g Release 2)?()A. Alert log fileB. Archived redo log filesC. Control file autobackupsD. Server Parameter file (SPFILE)E. Recovery Manager (RMAN) bac

题目
Which three types of files can be automatically placed in the flash recovery area (fast recovery area in 11g Release 2)?()

A. Alert log file

B. Archived redo log files

C. Control file autobackups

D. Server Parameter file (SPFILE)

E. Recovery Manager (RMAN) backup piece

相似考题

1.Which options would you consider while configuring a flash recovery area (fast recovery area in 11g Release 2) for your production database that is running in ARCHIVELOG mode?()A. Setting the FAST_START_MTTR_TARGET to set the mean time to recoverB. Setting the RECOVERY_PARALLELISM parameter to twice the number of CPUsC. Using the DB_RECOVERY_FILE_DEST parameter to set the location for flash recovery areaD. Using the DB_RECOVERY_FILE_DEST_SIZE parameter to define the disk space limit for the recovery files created in the flash recovery area

2.YoudecidetoenableFlashbackDatabaseinyourOracle10gdatabasesothatfuturerecoverieswilltakelesstimethantraditionalrecoveries.WhichofthefollowingparametersmustbeincludedinyourinitializationparameterfilebeforeenablingFlashbackDatabase？（）A.DB_RECOVERY_FILE_DESTonlyB.DB_FLASHBACK_RETENTION_TARGETonlyC.DB_RECOVERY_FILE_DEST_SIZEandDB_RECOVERY_FILE_DESTonlyD.DB_RECOVERY_FILE_DESTandDB_FLASHBACK_RETENTION_TARGETonlyE.DB_RECOVERY_FILE_DEST_SIZE，DB_RECOVERY_FILE_DESTandF.DB_FLASHBACK_RETENTION_TARGET

3.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？（）

4.Youaretryingtorecoveryourdatabase.Duringtherecoveryprocess，youreceivethefollowingerror：ORA-00279：change5033391generatedat08/17/200806：37：40neededforthread1ORA-00289：suggestion：/oracle01/flash_recovery_area/ORCL/archivelog/2008_08_17/o1_mf_1_11_%u_.arcORA-00280：change5033391forthread1isinsequence#11ORA-00278：logfile，，/oracle01/flash_recovery_area/ORCL/archivelog/2008_08_17/o1_mf_1_10_4bj6wnqm_.arcnolongerneededforthisrecoverySpecifylog：{=suggested|filename|AUTO|CANCEL}ORA-00308：cannotopenarchivedlog，，/oracle01/flash_recovery_area/ORCL/archivelog/2008_08_17/o1_mf_1_11_%u_.arcORA-27037：unabletoobtainfilestatusLinuxError：2：NosuchfileordirectoryAdditionalinformation：3Howdoyourespondtothiserror？（）

参考答案和解析
参考答案：B, C, E
更多“Which three types of files can be automatically placed in the flash recovery area (fast recovery area in 11g Release 2)?() ”相关问题

  • 第1题：

    在OSPF协议中,核心的Area为()。

    A.Area0

    B.Area1

    C.Area2

    D.自定义


    答案A

  • 第2题：

    Youneedtorecoverfivedatafilesthatarespreadacrossmultipledisks.Whichinitializationparametershouldyousettospeedupredoapplication?()

    A.RECOVERY_PARALLELISM

    B.FAST_START_MTTR_TARGET

    C.LOG_CHECKPOINT_INTERVAL

    D.FAST_START_PARALLEL_ROLLBACK


    参考答案：A

  • 第3题：

    毒理学研究中提倡3R原则是指

    A、replacement\reduction\refinement

    B、replacement\recovery\refinement

    C、replacement\reduction\reference

    D、replacement\recovery\reactivity

    E、replacement\recovery\reference


    参考答案：A

  • 第4题：

    下面哪2个参数是flashback databae必须设置的? ()

    A. DB_FLASHBACK_RETENTION_TARGET

    B. DB_RECOVERY_FILE_DEST

    C. RECOVERY_PARALLELISM

    D. FLASHBACK_TRANSACTION_QUERY

    E. DB_RECOVERY_FILE_DEST_SIZE


    参考答案BE

  • 第5题：

    WhichthreeinitializationparametersarenolongerneededwhenFAST_START_MTTR_TARGETisdefined?()

    A.TARGET_REDO_BLKS

    B.FAST_START_IO_TARGET

    C.LOG_CHECKPOINT_TIMEOUT

    D.RECOVERY_ESTIMATED_IOS

    E.LOG_FILE_SIZE_REDO_BLKS

    F.LOG_CHECKPOINT_INTERVAL


    参考答案：B, C, F

  • 第6题：

    配置OSPF路由，必须需要具有的网络区域是：

    A．Area0

    B．Area1

    C．Area2

    D．Area3


    Area0

相关内容