Multiple choice technology databases

Which of the following DB2 data types does NOT have a fixed length?

  1. INT

  2. CHAR

  3. XML

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

Fixed-length data types always occupy the same storage regardless of actual content. INT is always 4 bytes, CHAR(n) always uses exactly n bytes, and DOUBLE is always 8 bytes. XML is a variable-length type that stores XML documents and consumes space based on the actual XML content size, making it the correct answer.

Keep practicing — related questions