A. Flashback Table can be performed on system tables.
B. Flashback Table operation does not shrink the segments.
C. Flashback Table uses log mining to extract SQL_REDO and SQL_UNDO statements.
D. Flashback Table operation acquires exclusive data manipulation language (DML) locks.
第1题:
YoudecidetoenableFlashbackDatabaseinyourOracle10gdatabasesothatfuturerecoverieswilltakelesstimethantraditionalrecoveries.WhichofthefollowingparametersmustbeincludedinyourinitializationparameterfilebeforeenablingFlashbackDatabase?()
A.DB_RECOVERY_FILE_DESTonly
B.DB_FLASHBACK_RETENTION_TARGETonly
C.DB_RECOVERY_FILE_DEST_SIZEandDB_RECOVERY_FILE_DESTonly
D.DB_RECOVERY_FILE_DESTandDB_FLASHBACK_RETENTION_TARGETonly
E.DB_RECOVERY_FILE_DEST_SIZE,DB_RECOVERY_FILE_DESTand
F.DB_FLASHBACK_RETENTION_TARGET
第2题:
A.QuerytheV$FLASHBACK_DATABASE_LOGview.
B.QuerytheV$FLASHBACK_DATABASE_STATview.
C.CheckthevalueoftheDB_FLASHBACK_RETENTION_TARGETinitializationparameter.
D.QuerytheV$RECOVERY_FILE_DESTview.
第3题:
第4题:
YouareworkingasaDBAatNetFxCorporation.YoudiscoverthattheSCOTTschemaisdeletedbymistake.Youdecidetoflashthedatabasebacktothetimewhentheschemaexisted.Whichviewwillyouquerytodeterminetheestimatedsizeoftheflashbackdatathatyourequireforyourcurrenttargetretention?()
A.V$FLASHBACK_DATABASE_LOG
B.V$FLASHBACK_DATABASE_STAT
C.V$DATABASE
D.V$UNDOSTAT
第5题:
A.Thetimewhenthelastflashbackoperationinyourdatabasewasperformed.
B.Thetimewhenthefirstflashbackoperationinyourdatabasewasperformed.
C.AlistofflashbackoperationsperformedinyourdatabaseusingSCNandtime.
D.Theapproximatetimeandthelowestsystemchangenumber(SCN)towhichyoucanflashbackyourdatabase.
第6题: