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?

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 *