In which situation can you use Flashback Database?TO BEFORE RESETLOGS Returns the database to its state including all changes up to the SCN of the most recent OPEN RESETLOGS. Note:FLASHBACK DATABASE can only return the database to a point before the most recent OPEN RESETLOGS operation if your database has been upgraded to Oracle Database 10g Release 2 or later. http://docs.oracle.com/cd/B28359_01/backup.111/b28273/rcmsynta023.htm#RCMRF194
Question:
Which situation can you use Flashback Database?
Options:
when undoing a shrink data file operation
when retrieving a dropped tablespace
when returning to a point in time before the restoration or re-creation of a control file
when returning to a point in time before the most recent open resetlogs operation
Correct Answer
The Correct Answer for this Question is
when returning to a point in time before the most recent open resetlogs operation