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
54.You decided to change the location of the flash recovery area. You executed the following command:ALTER SYSTEM SET DB_RECOVERY_FILE_DEST='+disk1' SCOPE=BOTH SID='*';
Which statement is true?
A. The location can be changed only if the flash recovery area is empty.
B. After executing the command, all new flash recovery area files will be created in the new location.
C. The command will generate an error because you cannot change the flash recovery area while the database is open.
D. All the existing files in the flash recovery area will be moved to the new location, and all new Flash Recovery Area files will be created in the new location.
Answer:B
Powered By