You are working on an Oracle Database 10g database. Because of data loss, you decided to perform a Flashback Database operation using the following command:
SQL> FLASHBACK DATABASE TO TIMESTAMP(SYSDATE – 5/24);
Which two statements are true? (Choose two.)
A.
SYSDATE should not be used with TIMESTAMP.
B.
The database must have multiplexed redo log files.
C.
The database must be in the MOUNT state to execute the command.
D.
The database must be opened with the RESETLOGS option after the flashback operation.
E.
The entire database needs to be restored from the most recent backup before the flashback operation.
Explanation:
The database must be mounted in exclusive mode to issue the FLASHBACK DATABASE command and must be opened with the RESETLOGS option when finished.