Oracle Database Administration II — Question 53

Which two are true about automatic block repair? (Choose two.)

Answer options

• A. Automatic block repair can repair blocks with no standby database if DB_BLOCK_CHECKING = TRUE.
• B. Real-Time Query must be enabled on a physical standby database for automatic block repair to be done on that physical standby database.
• C. Real-Time Query must be enabled on a primary database for automatic block repair to be done on any of its physical standby databases.
• D. It is not possible for media corrupt blocks.
• E. Real-Time Query must be enabled on a physical standby database for automatic block repair to be done on its primary database.

Correct answer: B, C

Explanation

The correct answers are B and C because automatic block repair relies on Real-Time Query being enabled on the respective databases. Option A is incorrect because automatic block repair does not require a primary database for blocks to be repaired. Option D is inaccurate as media corrupt blocks can be addressed through other means, and option E incorrectly states the requirement for the primary database to depend on the standby database.