nerdexam
Oracle

1Z0-043 · Question #91

The DB_BLOCK_CHECKING initialization parameter is set to TRUE. What would be the result of this setting on the data blocks being written to the datafiles, every time the DBWn writes?

The correct answer is A. The Oracle database will check all data blocks by going through the data on each block, making sure. See the full explanation below for the reasoning.

Question

The DB_BLOCK_CHECKING initialization parameter is set to TRUE. What would be the result of this setting on the data blocks being written to the datafiles, every time the DBWn writes?

Options

  • AThe Oracle database will check all data blocks by going through the data on each block, making sure
  • BThe DBWn and the direct loader will calculate a checksum and store it in the cache header of every
  • CThe Oracle database will check data blocks belonging to the SYSTEM tablespace only, by going through
  • DThe Oracle database will check data blocks belonging to the SYSAUX tablespace only, by going through
  • EThe Oracle database will check data blocks in the SYSTEM and SYSAUX tablespaces only, by going

How the community answered

(35 responses)
  • A
    83% (29)
  • B
    9% (3)
  • D
    3% (1)
  • E
    6% (2)

Community Discussion

No community discussion yet for this question.

Full 1Z0-043 Practice