In which situation can you use Flashback Database?
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
Explanation:
http://docs.oracle.com/cd/B28359_01/backup.111/b28273/rcmsynta023.htm (prerequisites, third para)
http://docs.oracle.com/cd/B28359_01/backup.111/b28273/rcmsynta023.htm#RCMRF194
D
Here is the command:
“FLASHBACK DATABASE TO BEFORE RESETLOGS;”
https://docs.oracle.com/database/121/BRADV/rcmflash.htm#BRADV80055
You cannot use Flashback Database to undo a shrink data file operation.
You cannot use Flashback Database alone to retrieve a dropped data file.
You cannot use FLASHBACK DATABASE to return to a point in time before the restore or re-creation of a control file.
https://docs.oracle.com/database/121/BRADV/flashdb.htm#BRADV286