Oracle
1Z0-043 · Question #46
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…
The correct answer is 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. See the full explanation below for the reasoning.
Question
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.)
Options
- ABEGIN_TIME is the time at which Flashback logging is enabled.
- BEND_TIME is the time at which the query is executed on the view.
- CREDO_DATA is the number of bytes of redo data written during the interval.
- DThis view contains information about flashback data pertaining to the last 24 hours.
- EFLASHBACK_DATA is the amount of flashback data generated since the database was opened.
How the community answered
(34 responses)- A9% (3)
- B15% (5)
- C74% (25)
- E3% (1)
Community Discussion
No community discussion yet for this question.