A. The database must have multiplexed redo log files
B. The database must be in the MOUNT state to execute the command
C. The database must be in the NOMOUNT state to execute the command
D. The database must be opened in RESTRICTED mode before this operation
E. The database must be opened with the RESETLOGS option after the flashback operation
第1题:
YouareworkingasaDBAatNetFxCorporation.YoudiscoverthattheSCOTTschemaisdeletedbymistake.Youdecidetoflashthedatabasebacktothetimewhentheschemaexisted.Whichviewwillyouquerytodeterminetheestimatedsizeoftheflashbackdatathatyourequireforyourcurrenttargetretention?()
A.V$FLASHBACK_DATABASE_LOG
B.V$FLASHBACK_DATABASE_STAT
C.V$DATABASE
D.V$UNDOSTAT
第2题:
At10:30A.M.,youranabatchjobbymistake,whichexecutedatransactioninthedatabase.Thetransactionidentifierofthetransactionthatmadetothechangesinthedatabaseis0500A00627B000.At11:10A.M.,youstoppedthebatchjob.Now,youwanttoidentifythechangesmadetothedatabasetablesbythebatchjob.Whichviewwillyouquery?()
A.DBA_PENDING_TRANSACTIONS
B.DBA_AUDIT_STATEMENT
C.V$FLASHBACK_DATABASE_STATS
D.FLASHBACK_TRANSACTION_QUERY
第3题:
YouaremaintainingtheSALESdatabaseforanorganization.YouhaveenabledtheFlashbackDatabasefeatureandwanttoestimatetheflashbackspacerequiredforfutureoperations.Whichviewwouldyouquerytoestimatetheflashbackspacerequired?()
A.V$DATABASE
B.V$FLASHBACK_DATABASE_STAT
C.V$FLASHBACK_DATABASE_LOG
D.V$RECOVERY_FILE_DEST
第4题:
FlashbackDatabaseisenabledinyourOracle10gdatabase.Oneofyourdatabaseuserserroneouslypurgedanimportanttableresidinginhisschema.Thetablewaspurgedsometimebetween10:00P.M.and10:30P.M.Thenextday,youdecidetoflashbackthedatabase.Beforeyouflashbackthedatabase,youwanttoensurethatyouhaveallthenecessaryflashbackdata.Whichdynamicperformanceviewmustyouusetodeterminewhetheryouhavetherequiredflashbackdatatorecoverthepurgedtable?()
A.V$DATABASE
B.V$UNDOSTAT
C.V$FLASHBACK_DATABASE_LOG
D.V$FLASHBACK_DATABASE_STAT
第5题:
A.QuerytheV$FLASHBACK_DATABASE_LOGview.
B.QuerytheV$FLASHBACK_DATABASE_STATview.
C.CheckthevalueoftheDB_FLASHBACK_RETENTION_TARGETinitializationparameter.
D.QuerytheV$RECOVERY_FILE_DESTview.
第6题:
A.Thetimewhenthelastflashbackoperationinyourdatabasewasperformed.
B.Thetimewhenthefirstflashbackoperationinyourdatabasewasperformed.
C.AlistofflashbackoperationsperformedinyourdatabaseusingSCNandtime.
D.Theapproximatetimeandthelowestsystemchangenumber(SCN)towhichyoucanflashbackyourdatabase.