Multiple choice technology databases

Table TABLE1 needs to hold specific numeric values up to 9999999.999 in column COL1. COL1 is also used to perform arithmetic operations. Which of the following would be the most appropriate DB2 data type to use for column COL1?

  1. INTEGER

  2. REAL

  3. NUMERIC(7, 3)

  4. DECIMAL(10, 3)
Reveal answer Fill a bubble to check yourself
D Correct answer
Explanation

DECIMAL(10, 3) can store values up to 9999999.999 (10 total digits, 3 after decimal) and supports arithmetic operations. INTEGER doesn't support decimals, REAL is floating-point with potential precision loss, and NUMERIC(7, 3) only supports up to 9999.999 which is insufficient for the required range.

Keep practicing — related questions