what information can you derive from the output of the …

You executed the following query:
SELECT oldest_flashback_scn, oldest_flashback_time
FROM V$FLASHBACK_DATABASE_LOG;
Considering that all the redo logs are available, what information can you derive from the output of the
preceding query?

You executed the following query:
SELECT oldest_flashback_scn, oldest_flashback_time
FROM V$FLASHBACK_DATABASE_LOG;
Considering that all the redo logs are available, what information can you derive from the output of the
preceding query?

A.
The time when the last flashback operation in your database was performed

B.
The time when the first flashback operation in your database was performed

C.
The approximate time and the lowest system change number (SCN) to which you can flash back your
database

D.
The system change number (SCN) and the time when the Flashback Database was enabled in the
database instance

Explanation:
V$FLASHBACK_DATABASE_LOG displays information about the flashback data. Use this view to help
estimate the amount of flashback space required for the current workload.



Leave a Reply 0

Your email address will not be published. Required fields are marked *