You want to flash back a test database by five hours.You issue this command:SQL > FLASHBACK DATABASE TO TIMESTAMP (SYSDATE － 5／24);Which two statements are true about this flashback scenario?() A. The database must have multiplexed redo logs for the flashback to succeed.B. The database must be MOUNTED for the flashback to succeed.C. The database must use block change tracking for the flashback to succeed.D. The database must be opened in restricted mode for the flashback to succeed.E. The database must be opened with the RESETLOGS option after the flashback is complete.F. The database must be opened in read-only mode to check if the database has been flashed back to the correct SCN.
You want to flash back a test database by five hours.You issue this command:SQL > FLASHBACK DATABASE TO TIMESTAMP (SYSDATE － 5／24);Which two statements are true about this flashback scenario?()
A. The database must have multiplexed redo logs for the flashback to succeed.
B. The database must be MOUNTED for the flashback to succeed.
C. The database must use block change tracking for the flashback to succeed.
D. The database must be opened in restricted mode for the flashback to succeed.
E. The database must be opened with the RESETLOGS option after the flashback is complete.
F. The database must be opened in read-only mode to check if the database has been flashed back to the correct SCN.
相关考题：
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
Youexecutedthefollowingqueryinyourdatabase:FROMV$FLASHBACK_DATABASE_LOGWhatwouldyoudeterminefromtheoutput?() A.thetimewhenthelastflashbackoperationinyourdatabasewasperformedB.thetimewhenthefirstflashbackoperationinyourdatabasewasperformedC.alistofflashbackoperationsperformedinyourdatabaseusingSCNandtimeD.theapproximatetimeandthelowestsystemchangenumber（SCN）towhichyoucanflashbackyourdatabase
ThesearethedetailsaboutV$FLASHBACK_DATABASE_STAT：SQLDESCV$FLASHBACK_DATABASE_STATNameNull？Type-----------------------------------BEGIN_TIMEDATEEND_TIMEDATEFLASHBACK_DATANUMBERDB_DATANUMBERREDO_DATANUMBERESTIMATED_FLASHBACK_SIZENUMBERWhichtwostatementsregardingtheV$FLASHBACK_DATABASE_STATviewaretrue？（）A.BEGIN_TIMEisthetimeatwhichFlashbackloggingisenabled.B.END_TIMEisthetimeatwhichthequeryisexecutedontheview.C.REDO_DATAisthenumberofbytesofredodatawrittenduringtheinterval.D.Thisviewcontainsinformationaboutflashbackdatapertainingtothelast24hours.E.FLASHBACK_DATAistheamountofflashbackdatageneratedsincethedatabasewasopened.
YouaremaintainingyourdatabaseinOracle10g.YouhavesetthevalueoftheSTATISTICS_LEVELinitializationparametertoTYPICALandthevalueoftheFAST_START_MTTR_TARGETparameterto900seconds.Toincreasetheperformanceofthedatabase，youwanttodeterminetheoptimalsizeoftheonlineredologfiles.Whichtoolenablesyoutodeterminetheoptimalsizeoftheonlineredologfiles？（）A.OracleEnterpriseManagerB.TheV$LOGviewC.TheV$LOGFILEviewD.TheV$FLASHBACK_DATABASE_LOGSview
YouareworkingasaDBAatNetFxCorporation.YoudiscoverthattheSCOTTschemaisdeletedbymistake.Youdecidetoflashthedatabasebacktothetimewhentheschemaexisted.Whichviewwillyouquerytodeterminetheestimatedsizeoftheflashbackdatathatyourequireforyourcurrenttargetretention？（）A.V$FLASHBACK_DATABASE_LOGB.V$FLASHBACK_DATABASE_STATC.V$DATABASED.V$UNDOSTAT
FlashbackDatabaseisenabledinyourOracle10gdatabase.Oneofyourdatabaseuserserroneouslypurgedanimportanttableresidinginhisschema.Thetablewaspurgedsometimebetween10：00P.M.and10：30P.M.Thenextday，youdecidetoflashbackthedatabase.Beforeyouflashbackthedatabase，youwanttoensurethatyouhaveallthenecessaryflashbackdata.Whichdynamicperformanceviewmustyouusetodeterminewhetheryouhavetherequiredflashbackdatatorecoverthepurgedtable？（）A.V$DATABASEB.V$UNDOSTATC.V$FLASHBACK_DATABASE_LOGD.V$FLASHBACK_DATABASE_STAT
At10：30A.M.，youranabatchjobbymistake，whichexecutedatransactioninthedatabase.Thetransactionidentifierofthetransactionthatmadetothechangesinthedatabaseis0500A00627B000.At11：10A.M.，youstoppedthebatchjob.Now，youwanttoidentifythechangesmadetothedatabasetablesbythebatchjob.Whichviewwillyouquery？（）A.DBA_PENDING_TRANSACTIONSB.DBA_AUDIT_STATEMENTC.V$FLASHBACK_DATABASE_STATSD.FLASHBACK_TRANSACTION_QUERY
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
Youexecutedthefollowingqueryinyourdatabase:SELECToldest_flashback_scn,oldest_flashback_timeFROMV$FLASHBACK_DATABASE_LOG;Whatwouldyoudeterminefromthe output?() A.Thetimewhenthelastflashbackoperationinyourdatabasewasperformed.B.Thetimewhenthefirstflashbackoperationinyourdatabasewasperformed.C.AlistofflashbackoperationsperformedinyourdatabaseusingSCNandtime.D.Theapproximatetimeandthelowestsystemchangenumber（SCN）towhichyoucanflashbackyourdatabase.