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.