You need to restore your database back to 9/30/2008 at 18：00

第1题：

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.

第2题：

Your database runs in NOARCHIVELOG mode， and is backed up every night using RMAN scripts. However， last night your assistant DBA performed a manual operating system backup， instead of running the scripts. Today your database crashed and you now want to use the backups from last night. What do you need todo？（）

• A、You need to perform the restore and recover operations manually, because the backup was made manually. 
• B、First you need to resynchronize the catalog with the control file, and then you can use RMAN to recover the database. 
• C、First you need to add the backup to the catalog using the CATALOG command, and then you can use RMAN to recover the database. 
• D、You can just use RMAN and recover the database, because RMAN automatically updates the catalog with the backup information. 

第3题：

You have lost datafile 4 from your database. Which is typically the fastest way to restore your database？（）  

• A、 Restore and recover the datafile.
• B、 Restore and recover the tablespace.
• C、 Restore and recover the database.
• D、 Restore and recover the control file.
• E、 Restore and recover the parameter file.

第4题：

You are maintaining the PROD database for NetFx Corporation. You have configured controlfile autobackup in your database. At 6：00 P.M. on Monday， you issue the following command：       RMAN>BACKUP DATABASE；  At 8：00 A.M. on Tuesday， you are unable to start the database because all the control files are missing. You decide to restore the control files from the backup by using the RMAN> RESTORE CONTROLFILE FROM AUTOBACKUP； command. Which operation should you perform before using the RMAN> RESTORE CONTROLFILE FROM AUTOBACKUP； command？（）

• A、 Start the database in the MOUNT stage.
• B、 Back up the control file to trace.
• C、 Set the DBID
• D、 Issue the RECOVER DATABASE command.

第5题：

You need to restore your database back to 9/30/2008 at 18：00. In what order would you run the following commands to compete this task？（）   a. restore controlfile until time `09/30/2008：18：00：00’ b. restore database until time `09/30/2008：18：00：00’  c. restore spfile until time `09/30/2008：18：00：00’ d. recover database until time `09/30/2008：18：00：00’ e. alter database open resetlogs f. alter database open

• A、 b， d， e
• B、 b， d， f
• C、 c， a， b， d， e
• D、 c， a， b， d， f
• E、 a， b， d， e

第6题：

A data file became corrupted in your database due to bad sectors on the disk. Because of corruption， you lost all the important tables in that data file. Which method would you use for recovery？（）

• A、flash back all the tables in the data file， one by one
• B、restore the data file to a new location and perform a media recovery
• C、flash back the database; there is no need to restore the data file
• D、restore the data file from the most recent backup and flash back the database

第7题：

You work as a database administrator for Certkiller .com. Your database is in NOARCHIVELOG mode. The database has been configured with three redo logs groups， and there have been five log switches. You lost one non-system-critical data file from your database.  Which method would you use to recover the data file？（）

• A、Restore all the data files and open the database
• B、Create the data file and performtablespacerecovery
• C、No need to restore any file， just recover the database
• D、Restore only the system data file and recover the database
• E、Restore only lost date file and performtablespacerecovery

第8题：

Which command will restore all datafiles to the date 9/30/2008 at 18:00 hours? （）

• A、restore datafiles until time '09/28/2008:21:03:11'
• B、restore database files until time '09/28/2008:18:00:00'
• C、restore database until time '09/28/2008:18:00:00'
• D、recover database until time '09/28/2008:18:00:00'
• E、recover database until timestamp '09/28/2008:18:00:00'

第9题：

A data file become corrupted in your database due to bad sectors on the disk. Because of corruption， you lost all the important tables in that data file. Which method would you use for recovery？（）

• A、 Flash back all the tables in the data file， one by one.
• B、 Restore the data file to a new location and perform a media recovery.
• C、 Flash back the database， there is no need to restore the data file.
• D、 Restore the data file from the most recent backup and flash the database.

第10题：

Flashback Database is enabled in your Oracle 10g database. One of your database users erroneously purged an important table residing in his schema. The table was purged sometime between 10：00 P.M. and 10：30 P.M. The next day， you decide to flash back the database. Before you flash back the database， you want to ensure that you have all the necessary flashback data. Which dynamic performance view must you use to determine whether you have the required flashback data to recover the purged table？（）

• A、 V$DATABASE
• B、 V$UNDOSTAT
• C、 V$FLASHBACK_DATABASE_LOG
• D、 V$FLASHBACK_DATABASE_STAT