【单选题】You are maintaining the SALES database for an organization. You have enabled the Flashback Database feature and want to estimate the flashback space required for future operations. Which view would y...
【多选题】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...
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.
【单选题】You are working on the APPDB database as a DB A. The database has a default Flashback Data Archive DFLA1 created on it. You issued the following command to drop the Flashback Archive FLA1: DROP FLAS...
A.
The Flashback Archive FLA1 is dropped only if it is empty.
B.
The tablespace having Flashback Archive is dropped.
C.
The Flashback Archive FLA1 is dropped after moving the existing data in it to the default Flashback Archive.
D.
The Flashback Data Archive and historical data are dropped.