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

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 recover

B. Setting the RECOVERY_PARALLELISM parameter to twice the number of CPUs

C. Using the DB_RECOVERY_FILE_DEST parameter to set the location for flash recovery area

D. Using the DB_RECOVERY_FILE_DEST_SIZE parameter to define the disk space limit for the recovery files created in the flash recovery area


相关考题:

On Friday at 11:30 am you decided to flash back the database because of a user error that occurred at 8:30 am. Which option must you use to check whether a flashback operation can recover the database to the specified time? ()A. Check the alert log fileB. Query the V$FLASHBACK_DATABASE_LOG viewC. Query the V$RECOVERY_FILE_DEST_SIZE viewD.Query the V$FLASHBACK_DATABASE_STAT viewE. Check the value assigned for the UNDO_RETENTION parameter

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?()

Youarerequiredtoflashbackyourdatabase.Youwanttofindtheamountofflashbackdatageneratedsincethedatabasewasopened.Whichtaskwillyouperformtoobtaintherequiredinformation?() A.QuerytheV$FLASHBACK_DATABASE_LOGview.B.QuerytheV$FLASHBACK_DATABASE_STATview.C.CheckthevalueoftheDB_FLASHBACK_RETENTION_TARGETinitializationparameter.D.QuerytheV$RECOVERY_FILE_DESTview.

YouaremaintainingtheSALESdatabaseforanorganization.YouhaveenabledtheFlashbackDatabasefeatureandwanttoestimatetheflashbackspacerequiredforfutureoperations.Whichviewwouldyouquerytoestimatetheflashbackspacerequired?()A.V$DATABASEB.V$FLASHBACK_DATABASE_STATC.V$FLASHBACK_DATABASE_LOGD.V$RECOVERY_FILE_DEST

在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

YouwouldliketocreateanRMANrecovercatalog&e YouwouldliketocreateanRMANrecovercataloginwhichtostoreinformationaboutyourDB01database.YouwanttousethedatabasenamedRCDBforthestorageofyourrecoverycatalog.Thesixstepsyouwillfollowtocreatearecovercatalogarenotdisplayedinthecorrectorder.Whichdisplaysthecorrectorder?()1.Granttheappropriateprivileges(CONNECTandRESOURCE)androles(RECOVERY_CATALOG_OWNER)totheuserresponsibleforperformingbackupandrecoveroperations.2.Registerthetargetdatabaseinthecatalog.3.CreatethecatalogusingtheRMANcommandlineinterpreter.4.Createauserandschemawhichwillowntherecoverycatalog.5.CreatetablespacetoholdthecataloginthedatabaseyouhavededicatedforyourRMANrecoverycatalog.6.ConnecttothetargetdatabaseusingSYSDBAprivileges.

Youneedtorecoverfivedatafilesthatarespreadacrossmultipledisks.Whichinitializationparametershouldyousettospeedupredoapplication?() A.RECOVERY_PARALLELISMB.FAST_START_MTTR_TARGETC.LOG_CHECKPOINT_INTERVALD.FAST_START_PARALLEL_ROLLBACK