For which database operation would you need the database to 

第1题：

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

第2题：

For which database operation would you need the database to be in the MOUNT state（）

• A、renaming the control files
• B、re-creating the control files
• C、dropping a user in your database
• D、dropping a tablespace in your database
• E、configuring the database instance to operate in the ARCHIVELOG or NOARCHIVELOG modes

第3题：

Redo log files are multiplexed in your database. The disk in which you have one of the redo log members is highly fragmented. In the process of defragmentation you lose the redo log member， which is not a member of the current group. How would you recover from the loss of the redo log member？（）

• A、SMON would automatically restore the lost file.
• B、You would need to restore the whole database from the last backup.
• C、You would need to restore the file from the last full database backup.
• D、You would need to use flashback technology to restore the lost redo log member.
• E、You would need to use Recovery Manager （RMAN） to restore the lost redo log member.
• F、You would need to restore the missing log file by copying one of the remaining files from the same group.

第4题：

Which command would you use to determine what database backups are currently available for restore？（）  

• A、 list database backup
• B、 report database backup
• C、 list backup of database
• D、 list summary backup
• E、 report backup of database

第5题：

In which case would you use the Flashback Database feature to perform a recovery？（）

• A、to recover a dropped tablespace
• B、to recover data from a truncated table
• C、to recover a data file that has been shrunk
• D、to recover a database to the state that existed before the RESETLOGS operation

第6题：

You are managing an Oracle Database 11g database. The database is open， and you plan to perform Recovery Manager （RMAN） backups.  Which three statements are true about these backups（）

• A、The backups would be consistent.
• B、The backups would be inconsistent.
• C、The backups would be possible only if the database is running in ARCHIVELOG mode.
• D、The backups would be possible only if the database is running in NOARCHIVELOG mode.
• E、The backups need to be restored and the database has to be recovered in case of a media failure

第7题：

You have to shut down the database instance with the ABORT option because of a hardware failure. Which statement is true about the subsequent opening of the database？（）

• A、The database would open normally.
• B、The database would not open， and it would stop at mount stage.
• C、The database would open after automatically performing instance recovery.
• D、The database would not open， and you have to perform database recovery to open it.

第8题：

Your database is running in the ARCHIVELOG mode. You placed a tablespace， tbs_1， offline with the immediate option. Which statement is correct in this scenario？ （）

• A、The operation would fail if tbs_1 were a read-only tablespace.
• B、The operation would fail if tbs_1 were a read/write tablespace.
• C、The operation would fail if tbs_1 were the default tablespace for the database.
• D、If the above operation were successful， media recovery would be required to bring the tablespace online.
• E、If the above operation were successful， instance recovery would be required to bring the tablespace online.

第9题：

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

第10题：

You executed the following query in your database： SELECT oldest_flashback_scn， oldest_flashback_time FROM V$FLASHBACK_DATABASE_LOG； What would you determine from the output？（）

• A、 The time when the last flashback operation in your database was performed.
• B、 The time when the first flashback operation in your database was performed.
• C、 A list of flashback operations performed in your database using SCN and time.
• D、 The approximate time and the lowest system change number （SCN） to which you can flash back your database.