Multiple choice technology databases

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

  1. 10 bytes

  2. 2 bytes

  3. 5 bytes

  4. 4 bytes
Reveal answer Fill a bubble to check yourself
A Correct answer
Explanation

The TIMESTAMP data type in DB2 occupies 10 bytes of physical storage. This size accommodates the full precision needed to store date and time information including year, month, day, hour, minute, second, and fractional seconds. DATE requires 4 bytes and TIME requires 3-5 bytes depending on precision, but TIMESTAMP needs the full 10 bytes.

Keep practicing — related questions