Machine-translated by Google. Questions are authored in English.
Top

Discussion

In general, larger block sizes are used for online transaction processing applications and smaller block sizes are used for databases with a decision support or data warehousing system.

  • A.True
  • B.False

Answer: B

Correct answer: False

The sizes are the other way round. Transaction processing touches few rows at a time and benefits from small blocks, which reduce contention and wasted transfer. Warehousing scans large ranges, so large blocks bring more useful data per read. The statement has the two applications exchanged.

No comment is present. Be the first to comment.
Loading…

Post your comment

Please log in or register to post a comment.