The DB_BLOCK_CHECKING initialization parameter is set to OFF. Which block checking
would be performed?
A.
The Oracle database will perform block checking for the index blocks only
B.
The Oracle database will not perform block checking for any of the data blocks
C.
The Oracle database will perform block checking for the default permanent tablespace
only
D.
The Oracle database will perform block checking for the data blocks in all user
tablespaces
E.
The Oracle database will perform block checking for the data blocks in the SYSTEM
tablespace only
E is correct:
https://docs.oracle.com/cd/B19306_01/server.102/b14237/initparams039.htm#REFRN10029
OFF – no block checking is performed for blocks in the user tablespaces. However, semantic block checking for SYSTEM tablespace blocks is always turned on.