考题
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
考题
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?()
考题
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
考题
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?()
考题
在OSPF协议中,核心的Area为()。
A.Area0B.Area1C.Area2D.自定义
考题
下面哪2个参数是flashback databae必须设置的? ()
A. DB_FLASHBACK_RETENTION_TARGETB. DB_RECOVERY_FILE_DESTC. RECOVERY_PARALLELISMD. FLASHBACK_TRANSACTION_QUERYE. DB_RECOVERY_FILE_DEST_SIZE
考题
Youneedtorecoverfivedatafilesthatarespreadacrossmultipledisks.Whichinitializationparametershouldyousettospeedupredoapplication?()
A.RECOVERY_PARALLELISMB.FAST_START_MTTR_TARGETC.LOG_CHECKPOINT_INTERVALD.FAST_START_PARALLEL_ROLLBACK
考题
WhichthreeinitializationparametersarenolongerneededwhenFAST_START_MTTR_TARGETisdefined?()
A.TARGET_REDO_BLKSB.FAST_START_IO_TARGETC.LOG_CHECKPOINT_TIMEOUTD.RECOVERY_ESTIMATED_IOSE.LOG_FILE_SIZE_REDO_BLKSF.LOG_CHECKPOINT_INTERVAL
考题
毒理学研究中提倡3R原则是指A、replacement\reduction\refinementB、replacement\recovery\refinementC、replacement\reduction\referenceD、replacement\recovery\reactivityE、replacement\recovery\reference
考题
配置OSPF路由,必须需要具有的网络区域是:A.Area0B.Area1C.Area2D.Area3