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

The correct answer is B. Real-Time Query must be enabled on a physical standby database for automatic block repair to E. Real-Time Query must be enabled on a physical standby database for automatic block repair to. You can use an Oracle Active Data Guard standby database for automatic repair of data corruptions detected by the primary database. Additionally if the corruption is discovered on an Active Data Guard physical standby database the corruption will be automatically repaired with…

Manage Database Availability

Question

Options

AAutomatic block repair can repair blocks with no standby database if DB_BLOCK_CHECKING =
BReal-Time Query must be enabled on a physical standby database for automatic block repair to
CReal-Time Query must be enabled on a primary database for automatic block repair to be done
DIt is not possible for media corrupt blocks.
EReal-Time Query must be enabled on a physical standby database for automatic block repair to

How the community answered

(32 responses)

A
3% (1)
B
78% (25)
C
13% (4)
D
6% (2)

Explanation

You can use an Oracle Active Data Guard standby database for automatic repair of data corruptions detected by the primary database. Additionally if the corruption is discovered on an Active Data Guard physical standby database the corruption will be automatically repaired with a good block from the Primary.

Topics

#automatic block repair#physical standby#Real-Time Query#Data Guard

Community Discussion

No community discussion yet for this question.

Full 1Z0-083 Practice