Multiple choice technology databases

What is the Physical Storage Length of DATE DB2 data type?

  1. 2 Bytes

  2. 4 Bytes

  3. 8 Bytes

  4. 6 Bytes

Reveal answer Fill a bubble to check yourself
B Correct answer
Explanation

The DATE data type in DB2 uses 4 bytes of physical storage. This efficiently represents the date as a binary value encoding year, month, and day. The 4-byte format is compact compared to character representations while maintaining full date functionality.