1Z0-034 · Question #87
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…
The correct answer is C. The approximate time and the lowest system change number (SCN) to which you can flash back. 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.
Question
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?
Exhibit
Options
- AThe time when the last flashback operation in your database was performed
- BThe time when the first flashback operation in your database was performed
- CThe approximate time and the lowest system change number (SCN) to which you can flash back
- DThe system change number (SCN) and the time when the Flashback Database was enabled in
How the community answered
(50 responses)- A4% (2)
- B8% (4)
- C72% (36)
- D16% (8)
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.
Topics
Community Discussion
No community discussion yet for this question.