【多选题】You plan to execute the following command to perform a Flashback Database operation in your database: SQL> FLASHBACK DATABASE TO TIMESTAMP (SYSDATE -5/24); Which two statements are true about this...
A.
The database must have multiplexed redo log files
B.
The database must be in the MOUNT state to execute the command
C.
The database must be in the NOMOUNT state to execute the command
D.
The database must be opened in RESTRICTED mode before this operation
E.
The database must be opened with the RESETLOGS option after the flashback operation
【单选题】You executed the STARTUP MOUNT command to start your database. For which database operation do you need to start the database in the MOUNT state?()
A.
renaming the control files
B.
dropping a user in your database
C.
enabling or disabling redo log archiving
D.
dropping a tablespace in your database
E.
re-creating the control files, after you lost all the control files in your database
【多选题】You work as a database administrator for Certkiller .com. Your database is opened in NOARCHIVEKLOG mode. You decide to place the database in ARCHIVELOG mode. How would you do this?()
A.
Execute the ALTER DATABASE ARCHIVELOG statement
B.
Select ARCHIVELOG option in the database control and restart the database to apply the changes.
C.
Shut down and start the instance, and in the NOMOUNT state execute the ALTER DATABASE ARCHIVELOG statement.
D.
Shut down and start the instance, mount the database, then execute the ALTER DATABASE ARCHIVELOG statement.