Multiple choice technology mainframe

What is the Physical storage length of each of the following DB2 data types:DATE, TIME, TIMESTAMP.

  1. 6bytes, 4bytes, 13bytes

  2. 4bytes, 3bytes, 11bytes

  3. 4bytes, 3bytes, 10bytes

  4. 5bytes, 3bytes, 11bytes
Reveal answer Fill a bubble to check yourself
C Correct answer
Explanation

DATE stores 4 bytes (year, month, day), TIME stores 3 bytes (hours, minutes, seconds), and TIMESTAMP stores 10 bytes (combining date and time with fractional seconds). Option A has TIME at 6 bytes, Option B has TIMESTAMP at 11 bytes, and Option D has DATE at 5 bytes.

Keep practicing — related questions