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...


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.



Jan 15, 2022
SOLUTION.PDF

Get Answer To This Question

Related Questions & Answers

More Questions »

Submit New Assignment

Copy and Paste Your Assignment Here