Has DB2 NUMERIC data type?

hiolgc · #1 (**permalink**) 04-28-04, 09:11

Hi every one,

A DB2 mock question:

Given that table T1 needs to hold specific numeric values up to 99999.99 in column C1.
Which of the following would be the most exact definition for C1?

1. REAL
2. INTEGER
3. NUMERIC(7,2)
4. DECIMAL(5,2)

What's your answer?

Thanks,

hiolgc · #2 (**permalink**) 04-28-04, 09:35

Yes, there is NUMERIC. When a column is created with NUMRIC data type, it is changed to DECIMAL.

J Petruk · #3 (**permalink**) 04-28-04, 10:07

Quote:

Originally Posted by hiolgc

Hi every one,

A DB2 mock question:

Given that table T1 needs to hold specific numeric values up to 99999.99 in column C1.
Which of the following would be the most exact definition for C1?

1. REAL
2. INTEGER
3. NUMERIC(7,2)
4. DECIMAL(5,2)

What's your answer?

Thanks,

Is this from a test or something?

3.

REAL rounds, INTEGER can't store decimals, and your (5,2) definition would only store up to 999.99

Internet Services

Web Development

Digital Marketing

Consumer Tech