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

In DB2, the physical storage lengths are 4 bytes for DATE, 3 bytes for TIME, and 10 bytes for TIMESTAMP (for the standard default precision of 6).