Multiple choice technology databases

In NPS the minimum NPS row overhead is how many bytes

  1. 24

  2. 26

  3. 28

  4. 22
Reveal answer Fill a bubble to check yourself
C Correct answer
Explanation

In NPS (Netezza Performance Server), the minimum row overhead is 28 bytes. This is the storage overhead per row regardless of column data. This overhead includes metadata and structure information NPS needs to manage each row. The other values are incorrect NPS overhead specifications.

AI explanation

In IBM Netezza (NPS), each stored row carries a fixed minimum overhead of 28 bytes per row for internal bookkeeping (row header information such as version/visibility bits) before any column data is counted, which factors into capacity planning and row-size estimates. The other byte values (24, 26, 22) are simply incorrect figures for this documented internal constant.

Keep practicing — related questions