Oracle
1Z0-043 · Question #114
The DB_BLOCK_CHECKING initialization parameter is set to FALSE. What level of block checking would be performed?
The correct answer is D. The Oracle database will perform block checking for the data blocks in the SYSTEM tablespace only. See the full explanation below for the reasoning.
Question
The DB_BLOCK_CHECKING initialization parameter is set to FALSE. What level of block checking would be performed?
Options
- AThe Oracle database will not perform block checking for any of the data blocks.
- BThe Oracle database will perform block checking for the default permanent tablespace only.
- CThe Oracle database will perform block checking for the data blocks in all user tablespaces.
- DThe Oracle database will perform block checking for the data blocks in the SYSTEM tablespace only.
- EThe Oracle database will perform block checking for the data blocks in the SYSTEM and SYSAUX
How the community answered
(27 responses)- A7% (2)
- B4% (1)
- C15% (4)
- D70% (19)
- E4% (1)
Community Discussion
No community discussion yet for this question.