A. Flashback Database must be enabled.
B. Undo retention guarantee for the database must be configured.
C. EXECUTE privilege on the DBMS_FLASHBACK package must be granted to the user flashing back transaction.
D. Supplemental logging must be enabled.
E. Recycle bin must be enabled for the database.
F. Block change tracking must be enabled tor the database.
第1题:
A.QuerytheV$FLASHBACK_DATABASE_LOGview.
B.QuerytheV$FLASHBACK_DATABASE_STATview.
C.CheckthevalueoftheDB_FLASHBACK_RETENTION_TARGETinitializationparameter.
D.QuerytheV$RECOVERY_FILE_DESTview.
第2题:
A.Thetimewhenthelastflashbackoperationinyourdatabasewasperformed.
B.Thetimewhenthefirstflashbackoperationinyourdatabasewasperformed.
C.AlistofflashbackoperationsperformedinyourdatabaseusingSCNandtime.
D.Theapproximatetimeandthelowestsystemchangenumber(SCN)towhichyoucanflashbackyourdatabase.
第3题:
A.Youcanfindinformationaboutonlyactivetransactionsfromtheview
B.Youcanfindinformationaboutreadonlytransactionsfromtheview
C.YourequiretheSELECTANYTRANSACTIONsystemprivilegetoaccesstheview
D.Youcanfindinformationaboutbothactiveandcommittedtransactionsfromtheview
E.YourequiretheSELECTONFLASHBACK_TRANSACTION_QUERYobjectprivilegetoaccesstheview
第4题:
YouaremaintainingtheSALESdatabaseforanorganization.YouhaveenabledtheFlashbackDatabasefeatureandwanttoestimatetheflashbackspacerequiredforfutureoperations.Whichviewwouldyouquerytoestimatetheflashbackspacerequired?()
A.V$DATABASE
B.V$FLASHBACK_DATABASE_STAT
C.V$FLASHBACK_DATABASE_LOG
D.V$RECOVERY_FILE_DEST
第5题:
A. DB_FLASHBACK_RETENTION_TARGET
B. DB_RECOVERY_FILE_DEST
C. RECOVERY_PARALLELISM
D. FLASHBACK_TRANSACTION_QUERY
E. DB_RECOVERY_FILE_DEST_SIZE
第6题: