Which view would you query to determine whether the Flashback Database has been enabled?

You enabled Flashback Database with the following command:
ALTER DATABASE FLASHBACK ON;
Which view would you query to determine whether the Flashback Database has been enabled?

You enabled 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



Leave a Reply 0

Your email address will not be published. Required fields are marked *