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

Discussion

Which of the following is not a factor to consider when switching from small to large block size?

  • A.The length of all of the fields in a table row.
  • B.The number of columns
  • C.Block contention
  • D.Random row access speed

Answer: B

Correct answer: The number of columns

Block size decisions turn on how much data a read brings in and how many rows share a block, so row length, block contention and random access speed all bear on it. The number of columns matters only through its effect on the row length, and so is not a separate factor.

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

Post your comment

Please log in or register to post a comment.