🎴 Flashcard Mode
Mainframe Programming: JCL, DB2, COBOL, CICS, and VSAM
Card1 / 20
Mastered0
Review0
QuestionClick to flip
What is the Physical storage length of each of the following DB2 data types:DATE, TIME, TIMESTAMP.
AnswerClick to flip back
A
4bytes, 3bytes, 10bytes
💡 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.