单选题When you are performing media recover， and an archived log is lost or corrupt， which type of recover must you perform？（）A Until SCNB Until timeC Until cancelD Recover using backup control file.

第1题：

When you are performing media recover， and an archived log is lost or corrupt， which type of recover must you perform？（）

• A、Until SCN
• B、Until time
• C、Until cancel
• D、Recover using backup control file.

第2题：

Your Certkiller .com database is in ARCHIVELOG mode. The data file that belongs to the SYSTEMtablespacehas become corrupted. Up to what point can you recover the database？（）

• A、Until last commit
• B、Until the time you perform recovery
• C、Until the time the date file got corrupted
• D、Until the point where the last transaction begun
• E、You cannot recover the SYSTEMtablespaceand must re-create the database.

第3题：

第4题：

Your Supportcenter.cn database is in ARCHIVELOG mode. The data file that belongs to the SYSTEM tablespace has become corrupted. Up to what point can you recover the database？（）

• A、Until last commit
• B、Until the time you perform recovery
• C、Until the time the date file got corrupted
• D、Until the point where the last transaction begun
• E、You cannot recover the SYSTEMtablespaceand must re-create the database.

第5题：

You performed an incomplete recovery on your Oracle Database 10g database using the following command：   SQL> RECOVER DATABASE  2 UNTIL TIME ’2004-08-05：12：10：03’ 3 USING BACKUP CONTROLFILE；  In which situation would the above recovery be required？（）

• A、 A user table was lost at the specified time.
• B、 A redo log file was lost at the specified time.
• C、 The backup control file is on a faster disk than the current one.
• D、 The current control file has a different path compared with the intended time of recovery.
• E、 The current control file does not match the physical structure of the database at the intended time of recovery.

第6题：

You have discovered that one of three control files has been lost. What steps would you follow to recover that control file？（）   a. Shut down the database.  b. Restore a control-file copy from backup media.  c. Use the create control file command to create a new control file.  d. Copy the backup control file into place.  e. Create a new copy of the control file from one of the surviving control files.  f. Recover the database using the recover database using backup control file command.  g. Start up the database. 

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

第7题：

You are using the Block Media Recovery feature to recover the blocks that are marked corrupt since the last backup. Which view will you query to display information about the data blocks that are marked corrupt since the last backup？（）

• A、 V$BACKUP_CORRUPTION
• B、 V$COPY_CORRUPTION
• C、 V$DATABASE_BLOCK_CORRUPTION
• D、 RC_BACKUP_CORRUPTION

第8题：

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.

第9题：

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.

第10题：

You are performing an incomplete recovery because some important tables have been dropped and purged from the Recycle Bin. Which clause can you NOT use to perform the incomplete recovery by using the RMAN utility？（）

• A、 UNTIL CANCEL
• B、 UNTIL SCN
• C、 UNTIL SEQUENCE
• D、 UNTIL TIME