Which of the following statements are correct about flashback, undo, and retention? (Choose two answers.)
A. Setting RETENTION GUARANTEE on a user data tablespace will ensure that a Flashback Drop will succeed, if carried out within the UNDO_ RETENTION period.
B. Setting RETENTION GUARANTEE on an undo tablespace will ensure that a Flashback Query will succeed, if carried out within the UNDO_ RETENTION period.
C. RETENTION GUARANTEE defaults to true for undo tablespaces, and false for user data tablespaces.
D. Flashback Database will always succeed, if the DB_FLASHBACK_ RETENTION_TARGET instance parameter is less than the RETENTION_ GUARANTEE period.
E. Setting the RETENTION_GUARANTEE attribute can cause DML to fail.
Already registered? Login
Not Account? Sign up
Enter your email address to reset your password
Back to Login? Click here