单选题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？（）AV$BACKUP_CORRUPT

第1题：

According to your backup strategy， you performed an incremental level 0 backup of yourdatabase. Which statement regarding this backup is true？（）

• A、The backup is similar to image copy.
• B、The backup contains all used data blocks.
• C、The backup contains only unused data blocks.
• D、The backup contains all data blocks changed since the last incremental level 1 backup.

第2题：

You are managing an Oracle Database 11g database with this backup strategy：  - Every Sunday night， level 0 backup is performed.  - On Monday night and subsequent days， level 1 incremental backup is performed.  The backups are not cumulative incremental.  Which statement about Monday’s backup is true（）

• A、The backup contains all the used blocks.
• B、The backup contains all the used and unused blocks.
• C、The backup contains blocks that have changed since the last level 0 backup.
• D、The backup contains blocks that have changed since the last level 1 backup taken last week.

第3题：

You are performing a block media recovery on the tools01.dbf data file in the SALES database 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.

第4题：

You work as a database administrator for Certkiller .com. According to your backup strategy， you performed an incremental level 0 backup of your database. Which statement regarding this backup is true？（）

• A、The backup is similar to image copy.
• B、The backup contains all used data blocks.
• C、The backup contains only unused data blocks.
• D、The backup contains all data blocks changed since the last incremental level 1 backup.

第5题：

You perform differential incremental level 1 backups of your database on each working day and level 0 backupon Sundays， to tape. Which two statements are true about differential incremental backups（）

• A、The backup performed on Sundays contains all the blocks that have ever been used in the database.
• B、The backup performed on Sundays contains all the blocks that have changed since the last level 1 backup.
• C、The backup performed on each working day contains all the blocks that have changed since the last level 0 backup.
• D、The backup performed on Monday contains all the blocks that have changed since the level 0 backup， and every other working day contains all the blocks that have changed since the level 1 backup

第6题：

You execute the following RMAN command in the order shown below： BACKUP VALIDATE DATABASE； BLOCKRECOVER CORRUPTION LIST； What will these commands do？（）

• A、 Create a backup of the database and recover all corrupted blocks found in the backup.
• B、 Run a backup validation and list all the logically corrupt blocks as well as physically corrupt blocks in the database.
• C、 Run a backup validation to populate V$COPY_CORRUPTION view， and then list any corrupt blocks recorded in the view.
• D、 Run a backup validation to populate V$DATABASE_BLOCK_CORRUPTION view， and then repair any corrupt blocks recorded in the view.
• E、 Run a backup validation， repair any corrupt blocks found during the validation process， and then update V$DATABASE_BLOCK_CORRUPTION view to indicate which corrupt blocks have been repaired.

第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 perform differential incremental level 1 backups of your database on each working day and level 0 backup on Sundays， to tape.  Which two statements are true about differential incremental backups（）

• A、The backup performed on Sundays contains all the blocks that have ever been used in the database.
• B、The backup performed on Sundays contains all the blocks that have changed since the last level 1backup. 
• C、The backup performed on each working day contains all the blocks that have changed since the lastlevel 0 backup.
• D、The backup performed on Monday contains all the blocks that have changed since the level 0 backup，and every other working day contains all the blocks that have changed since the level 1 backup.

第14题：

Which of the following views must you query to identify any corrupt data file blocks that have been detected during backup set creation？（）

• A、V$COPY_CORRUPT
• B、V$COPY_CORRUPTION
• C、V$BACKUP_CORRUPT
• D、V$BACKUP_CORRUPTION

第15题：

You execute the following RMAN commands in the order shown below：  BACKUP VALIDATE DATABASE;  BLOCKRECOVER CORRUPTION LIST;  What will these commands do？（）

• A、create a backup of the database and recover all corrupted blocks found in the backup
• B、run a backup validation and list all the logically corrupt blocks as well as physically corrupt blocks in the database
• C、run a backup validation to populate V$COPY_CORRUPTION view， and then list any corrupt blocks recorded in the view
• D、run a backup validation to populate V$DATABASE_BLOCK_CORRUPTION view， and then repair any corrupt blocks recorded in the view
• E、run a backup validation， repair any corrupt blocks found during the validation process， and then update V$DATABASE_BLOCK_CORRUPTION view to indicate which corrupt blocks have been repaired

第16题：

Which two statements are true about Block Media Recovery （BMR）？（）

• A、 BMR increases the Mean Time To Recover （MTTR）.
• B、 BMR can only be implemented using Recovery Manager （RMAN）.
• C、 The blocks that need to be recovered are accessible during BMR.
• D、 BMR cannot be performed using cumulative incremental backups.
• E、 The datafile must be restored if most of the blocks in the datafile are corrupt.

第17题：

You executed the following code：   BACKUP VALIDATE DATABASE；   BLOCKRECOVER CORRUPTION LIST；  What will be the result of executing the above code？（）  

• A、 The code will run a backup validation to populate the V$BACKUP_CORRUPTION view and repair corrupt blocks， if any， recorded in the view.
• B、 The code will run a backup validate to populate the V$COPY_CORRUPTION view and then repair any corrupt blocks recorded in the view.
• C、 The code will runs a backup validate to populate the V$DATABASE_BLOCK_CORRUPTION view and then repair corrupt blocks， if any， recorded in the view.
• D、 The code will run a backup validate to populate the RC_BACKUP_CORRUPTION view and then repair corrupt blocks， if any， recorded in the view.

第18题：

Users complain SQL statements using a particular index fail. Using DBVERIFY， you find that two separate blocks in the index have become corrupt. The database data files for user data and index are very large.  What is the least disruptive recover strategy available in Oracle9i？（）

• A、Rebuild the index using the online option. 
• B、Take the individual data file offline (not the whole tablespace), restore and recover the data file from backup with RMAN, then set the data file online again. 
• C、Without setting the individual data file offline, use RMAN with Block Media Recovery to restore and recover only those blocks. 
• D、Take the individual data file (not the whole tablespace) offline, use RMAN with Block Media Recovery to restore and recover only those blocks, then set the data file online again.

第19题：

第20题：

第21题：

第22题：

第23题：