Oracle Database 12c: Advanced Administration — Question 175

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 because Flashback Database can be used to recover a dropped tablespace, restoring it to its prior state. Options A, C, and D refer to scenarios where Flashback Database is not applicable, as they involve operations that Flashback cannot reverse.