In which of the scenarios will the DBA perform recovery（）

第1题：

You are using Recovery wizard for performing incomplete recovery. Which of the following object types is NOT available in the Perform Recovery ：Type screen？（）

• A、 Whole database
• B、 Tablespaces
• C、 Datafiles
• D、 Archive logs
• E、 Redo logs

第2题：

You are in the middle of a transaction updating a very important table. The machine on which a database wasrunning reboots because of power outage. This caused a database instance failure. Which statement is true inthis situation（）

• A、The online redo log files and archived redo log files are required to accomplish the recovery.
• B、The uncommitted transaction will be committed at the next startup of the database instance.
• C、The uncommitted transaction is rolled back automatically at the next opening of the database.
• D、The DBA has to perform the recovery on the database to recover the uncommitted transaction

第3题：

Which of the following statements is NOT true about RMAN？（）

• A、It improves usability by enabling you to reuse the scripts to perform recovery operations.
• B、It detects block corruption while restoration and recovery operations.
• C、It enables you to perform block media recovery.
• D、It is capable to recover through unrecoverable operations， with only full database backups.

第4题：

You are performing an incomplete recovery because certain important tables were deleted and purged from the Recycle Bin. In which mode will you perform the recovery？（）

• A、 MOUNT mode
• B、 RESTRICTED mode
• C、 OPEN mode
• D、 NOMOUNT mode

第5题：

You are working on a 24x7 （available 24 hours per day， 7 days per week） production database. An operating system （OS） user deletes the alert log file accidentally. Which statement in this scenario is true？（）

• A、The database crashes.
• B、The DBA needs to re-create the file.
• C、The file gets re-created automatically.
• D、The file gets restored automatically from the last backup.
• E、The DBA needs to perform a complete database recovery.
• F、The DBA needs to perform an incomplete database recovery.

第6题：

Which of the following is needed to perform an ASR restore in Windows XP?（）

• A、Operating system CD
• B、Recovery console
• C、Vendor recovery CD
• D、ERD disk

第7题：

Because of a logical corruption in your production database, you wanted to perform Tablespace Point in Time Recovery (TSPITR). But before you start the recovery, you queried the TS_PITR_OBJECTS_TO_BE_DROPPED view and realized that there are a large number of objects that would be dropped when you start the recovery by using this method. You want to preserve these objects. Which option must you use to perform TSPITR and preserve the object?（）

• A、Perform Export before TSPITR and Import after TSPITR
• B、Move objects to another schema that has the same tablespace assigned
• C、Perform Incomplete Recovery before TSPITR with the Log Sequence Number (LSN)
• D、Perform Incomplete Recovery before TSPITR with the System Change Number (SCN)

第8题：

Given below is a list of scenarios： 1） A user terminates his session abnormally. 2） The connection between the server and the client application terminates because of a network failure. 3） A schema is accidentally dropped. 4） The tablespace is accidentally dropped from the database. 5） The hard disk gets corrupted and the data files in the disk are lost. 6） The database instance abnormally shuts down because of power failure.  Which scenarios require DBAintervention to perform recovery（）

• A、1， 3， and 6
• B、4， 5， and 6
• C、3， 4， and 5
• D、1， 2， and 6

第9题：

In your database， all the tablespaces are locally managed. You started Recovery Manager （RMAN） using recovery catalog and restored the control file by using the following command： RMAN> RESTORE CONTROLFILE;  Which two operations do you need to perform after restoring the control file from backup？（）

• A、shut down and restart the instance
• B、add new tempfiles to the temporary tablespaces after recovery
• C、perform a media recovery and open the database with the RESETLOGS option
• D、perform a media recovery and bring the database to NOARCHIVELOG mode

第10题：

You are performing a block media recovery on the tools01.dbf data file in the SALES database by using RMAN.   Which two statements are correct in this scenario？（）

• A、You must ensure that the SALES database is mounted or open.
• B、You must restore a backup control file to perform a block media recovery.
• C、You must take the tools01.dbf data file offline before you start a block media recovery.
• D、You must put the database in NOARCHIVELOG mode to perform a block media recovery.
• E、You can perform only a complete media recovery of individual blocks； point-in-time recovery of  individual data blocks is not supported.