On Friday at 11:30 am you decided to flash back the database because of a user error that occurred at 8:30
am.
Which option must you use to check whether a flashback operation can recover the database to the specified
time?
A.
Check the alert log file
B.
Query the V$FLASHBACK_DATABASE_LOG view
C.
Query the V$RECOVERY_FILE_DEST_SIZE view
D.
Query the V$FLASHBACK_DATABASE_STAT view
E.
Check the value assigned for the UNDO_RETENTION parameter
Explanation:
To query the V$FLASHBACK_DATABASE_LOG to get the lowest SCN or the nearest TIMESTAMP to decide
the recovery possibility.