You enable Flashback Database with the following command:
ALTER DATABASE FLASHBACK ON;
Which view would you query to determine whether the Flashback Database has been enabled?
A.
V$SGA
B.
V$DATABASE
C.
V$INSTANCE
D.
V$FLASHBACK_DATABASE_LOG
E.
V$FLASHBACK_DATABASE_STAT
F.
V$FLASHBACK_DATABASE_LOGFILE
Explanation:
SQL>DESC V$DATABASE;
Name Type
—————————————– ————- FLASHBACK_ON VARCHAR2(18)
SQL>select FLASHBACK_ON from V$DATABASE;
FLASHBACK_ON
——————
YES