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题：

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.

第2题：

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.

第3题：

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.

第4题：

The database is being restored from a closed backup. The data files， control files， password file， and parameter file are available， but the online redo logs are not. Because the online redo logs are not available， you must simulate recovery and alter the database open with the reset logs option so the online redo logs are created while the database opens. Which type of recover is used in this situation？（）

• A、until SCN
• B、until time
• C、until cancel
• D、using backup control file

第5题：

You lost the PRODSTD tablespace， which was read/write. The tablespace was read/x7fonly when the last backup was performed. How would you recover the tablespace？（）

• A、restore the tablespace from the backup; there is no need to apply the redo information 
• B、restore the full database to recover the data up to the point when you performed the backup 
• C、restore the tablespace from the backup， and then perform a recovery using the backup control file
• D、restore the tablespace from the backup， and then recover the tablespace; all the redo information from the point when the tablespace was made read/write is applied

第6题：

You lost the PRODSTD tablespace， which was read/write. The tablespace was read-only when the last backup was performed. How would you recover the tablespace？（）

• A、 restore the tablespace from the backup； there is no need to apply the redo information
• B、 restore the full database to recover the data up to the point when you performed the backup
• C、 restore the tablespace from the backup and then perform a recovery using the backup control file
• D、 restore the tablespace from the backup and then recover the tablespace； all the redo information from the point when the tablespace was made read/write is applied

第7题：

If you find errors in the view V$DATABASE_BLOCK_CORRUPTION with a status of MEDIA_CORRUPT， what RMAN command would you run to correct the problem？（）

• A、 recover lost blocks
• B、 recover corrupt blocks
• C、 recover media corrupt blocks from list
• D、 recover corrupt blocks from list
• E、 recover corruption list

第8题：

第9题：

第10题：

第11题：

第12题：

第13题：

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

第14题：

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.

第15题：

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

第16题：

You are maintaining your database in Oracle10g. You perform a full user-managed backup every Sunday at 8：00 P.M. Your database is running in ARCHIVELOG mode. On Monday， at 9：00 A.M.， a tablespace is dropped. You decide to perform incomplete recovery to recover the dropped tablespace.  Which two clauses can you use with the RECOVER command？（）

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

第17题：

In which scenario will you perform an incomplete recovery？（）

• A、 when a table is dropped and stored in the Recycle Bin
• B、 when all the control files are deleted
• C、 when a member of a multiplexed redo log group is dropped
• D、 when you are required to recover a table to its previous state

第18题：

In which scenario will you issue the following command？（）      SQL> RECOVER DATABASE UNTIL TIME ’2005-10-04 ： 12：09：08’ USING        BACKUP CONTROLFILE；

• A、 when all the control files are missing and only a binary backup of the current control file exists
• B、 when a multiplexed copy of the current control file is missing
• C、when all the control files are missing and only a script containing the CREATE CONTROLFILE statement exists
• D、 when the SPFILE is missing

第19题：

You have lost all your database control files. To recover them， you are going to use the results of the alter database backup controlfile to trace command. Your datafiles and your online redo logs are all intact.  Which of the following is true regarding your recovery？（）  

• A、 You will need to open the database with the resetlogs command.
• B、 All you need to do is execute the trace file from SQL*Plus and it will perform the recovery for you.
• C、 You will use the resetlogs version of the create controlfile command.
• D、 You will use the noresetlogs version of the create controlfile command.
• E、 You will use the trace file to create a backup control file， and then you will recover the database with the recover database using backup controlfile command

第20题：

第21题：

第22题：

第23题：