单选题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_CORRU

第1题：

While working on the database， you receive the following error：        01578： ORACLE data block corrupted （file# 6， block # 54）        ORA-01110 ： data file 6： ’u01/oracle/oradata/data1.dbf’   You decide to recover the corrupted data block by using the Block Media Recovery feature. Which option is NOT a disadvantage of using block media recovery？（）

• A、 Block Media Recovery must be used with RMAN.
• B、 You must perform complete recovery of individual blocks.
• C、 You must have a full RMAN backup， not an incremental backup.
• D、 You must use the DBVERIFY utility before using the Block Media Recovery feature.

第2题：

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.

第3题：

Which of the following is not an advantage of block media recovery （BMR）？（）

• A、 Reduced MTTR.
• B、 Datafiles remain offline while corrupt blocks are repaired.
• C、 Datafiles remain online while corrupt blocks are repaired.
• D、 A and C

第4题：

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.

第5题：

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.

第6题：

You issued the following command： ALTER DATABASE ENABLE BLOCK CHANGE TRACKING；  What will be the result of issuing this command？（）

• A、 The block change tracking feature is enabled， and the information about the system change number is written in the change tracking file.
• B、 The block change tracking feature is enabled， and the information about the log sequence number is written in the change tracking file.
• C、 The block change tracking feature is enabled， and the information about the blocks that are changed since the last backup is written in the change tracking file.
• D、 The block change tracking feature is enabled， and the information about the locations of the datafiles and the online redo log files are written in the change tracking file.

第7题：

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.

第8题：

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

第9题：

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

第10题：

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