Multiple choice technology mainframe

Which of the following DB2 data types CANNOT be used to contain the date an employee was hired?

  1. TIMESTAMP

  2. VARCHAR

  3. TIME

  4. CLOB
Reveal answer Fill a bubble to check yourself
C Correct answer
Explanation

TIME data type stores only time of day (hours, minutes, seconds), not the date component. Hiring an employee requires recording the full date (year, month, day). TIMESTAMP includes both date and time, VARCHAR can store date strings, and CLOB stores character large objects. TIME is the only type that cannot store a complete hire date.

Keep practicing — related questions