nerdexam
Oracle

1Z0-034 · Question #143

The DB_BLOCK_CHECKING parameter is set to FALSE. What level of block checking will be performed?

The correct answer is D. The Oracle database will perform block checking for the data blocks in the SYSTEM tablespace. See the full explanation below for the reasoning.

Question

The DB_BLOCK_CHECKING parameter is set to FALSE. What level of block checking will 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
  • EThe Oracle database will perform block checking for the data blocks in the SYSTEM and

How the community answered

(42 responses)
  • A
    2% (1)
  • B
    7% (3)
  • C
    2% (1)
  • D
    83% (35)
  • E
    5% (2)

Community Discussion

No community discussion yet for this question.

Full 1Z0-034 Practice