Multiple choice technology databases

Which of the following is a valid DB2 data type?

  1. NUMBER

  2. INTERVAL

  3. NUM

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

DB2 supports various built-in data types for different data storage needs. NUM is indeed a valid DB2 data type and serves as a synonym for NUMERIC, which stores exact numeric values with specified precision and scale. The other options are incorrect: NUMBER is an Oracle data type not used in DB2, INTERVAL is used for datetime arithmetic rather than being a standalone column type, and BYTE is not a standard DB2 data type. Understanding valid data types is crucial for proper database schema design.

Keep practicing — related questions