DB2 Database Fundamentals and SQL

Casual Mode - Take your time!

1 / 20
✓
Correct
0
✗
Incorrect
0
★
Score
0%
Multiple Choice

Given the following scenario: Table TABLE1 needs to hold specific numeric values up to 9999999.999 in column COL1. Once TABLE1 is populated, arithmetic operations will be performed on data stored in col-umn COL1. 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)
Change Mode