Upgrade Oracle DBA 11g to Oracle Database 12c — Question 2

In which situation can you use Flashback Database?

Answer options

• A. when undoing a shrink data file operation
• B. when retrieving a dropped tablespace
• C. when returning to a point in time before the restoration or re-creation of a control file
• D. when returning to a point in time before the most recent open resetlogs operation

Correct answer: B

Explanation

The correct answer is B, as Flashback Database can be utilized to recover dropped tablespaces. Options A, C, and D are incorrect because Flashback Database does not support undoing data file operations, nor does it work to revert the control file or to go back to a point before a resetlogs operation.