186. You executed the following query in your database:
FROM V$FLASHBACK_DATABASE_LOG?
What would you determine from the output?
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.a list of flashback operations performed in your database using SCN and time
D.the approximate time and the lowest system change number (SCN) to which you can flash back your
database

Answer: D

187. These are the details about V$FLASHBACK_DATABASE_STAT:
SQL> DESC V$FLASHBACK_DATABASE_STAT
Name Null? Type
BEGIN_
TIME DATE
END_TIME DATE
FLASHBACK_DATA NUMBER
DB_DATA NUMBER
REDO_DATA NUMBER
ESTIMATED_FLASHBACK_SIZE NUMBER
Which two statements regarding the V$FLASHBACK_DATABASE_STAT view are true? (Choose two.)
A.BEGIN_TIME is the time at which Flashback logging is enabled.
B.END_TIME is the time at which the query is executed on the view.

C.REDO_DATA is the number of bytes of redo data written during the interval.
D.This view contains information about flashback data pertaining to the last 24 hours.
E.FLASHBACK_DATA is the amount of flashback data generated since the database was opened.
Answer: CD

V$FLASHBACK_DATABASE_LOG

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.

V$FLASHBACK_DATABASE_STAT

V$FLASHBACK_DATABASE_STAT?displays statistics for monitoring the I/O overhead of logging flashback data. This view also displays the estimated flashback space needed based on previous workloads.