网友您好， 请在下方输入框内输入要搜索的题目：
题目内容
（请给出正确答案）
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
参考答案
更多 “ 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 ” 相关考题
考题
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
考题
下面哪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
热门标签
最新试卷
