View the Exhibit to examine a portion of the output from the VALIDATE DATABASE command.
Which statement is true about the block corruption detected by the command?
Exhibit:
A.
No action is taken except the output in the Exhibit.
B.
The ADVISE FAILURE command is automatically called to display the repair script.
C.
The failure is logged into the Automatic Diagnostic Repository (ADR).
D.
The corruption is repaired by the command implicitly.
Explanation:
Detection of Block Corruption (link)
Oracle Database supports different techniques for detecting, repairing, and monitoring block corruption. The
technique depends on whether the corruption is interblock corruption or intrablock corruption. In intrablock
corruption, the corruption occurs within the block itself. This corruption can be either physical or logical. In
aninterblock corruption, the corruption occurs between blocks and can only be logical.
For example, the V$DATABASE_BLOCK_CORRUPTION view records intrablock corruptions, while the
Automatic Diagnostic Repository (ADR) tracks all types of corruptions. Table 16-1 summarizes how the
database treats different types of block corruption.