Oracle Database Administration II — Question 125

Which three are true about block media recovery? (Choose three.)

Answer options

• A. The data file containing the block being recovered remains online.
• B. To use it, Flashback Database must be enabled.
• C. A block being recovered is not accessible.
• D. It can be performed on noncorrupt blocks.
• E. The target database for which one or more blocks are to be recovered must be in the OPEN state.
• F. It cannot repair logical corruption.

Correct answer: A, B, C

Explanation

The correct answers A, B, and C reflect the realities of block media recovery, where the data file remains online, Flashback Database must be enabled, and the block being recovered is not accessible during the process. Options D, E, and F are incorrect because block media recovery cannot be performed on noncorrupt blocks, the database does not need to be OPEN for recovery processes, and it cannot address logical corruption.