Which two statements are true about the RMAN VALIDATE DATABASE command? (Choose two.) 

Answer options:

A. It checks the database for intrablock corruptions.
B. It can detect corrupt pfiles.
C. It can detect corrupt spfiles.
D. It checks the database for interblock corruptions.
E. It can detect corrupt block change tracking files.

AC

Block corruptions can be divided Into Interblock corruption and intrablock corruption. In intrablock corruption. th corruption occurs within the block itself and can be either physical or logical corruption. In interblock corruption, the corruption occurs between blocks and can only be logical corruption. (key word) * The VALIDATE command checks for intrablock corruptions only. Only DBVERIFY and the ANALYZE statement detect Interblock corruption. VALIDATE Command Output > List of Control File and SPFILE. File TYPE > SPFILE or Control File. Status > OK if no corruption, or FAILED If block corruption is found. Blocks FailingThe number of blocks that fail the corruption check. These blocks are newly corrupt. Blocks ExaminedTotal number of blocks in the file. Oracle` Database Backup and Recovery User`s Guide 12c Release 1 (12.1) - 16 Validating Database Files and Backups