Which of the following DB2 data types can NOT be used to create an identity column?
A. SMALLINT
B. INTEGER
C. NUMERIC
D. DOUBLE
3 Comments on “Which of the following DB2 data types can NOT be used to create an identity column?”
WRsays:
D
0
0
Chow, Kenneth KYsays:
Only columns of type SMALLINT, INTEGER, BIGINT, DECIMAL, or NUMERIC can be created as identity columns.
0
0
Chow, Kenneth KYsays:
DOUBLE A double-precision floating-point number is a long floating-point number of 64-bits. The range of double-precision floating-point numbers is approximately -7.2E+75 to 7.2E+75. In this range, the largest negative value is about -5.4E-79, and the smallest positive value is about 5.4E-79.
D
0
0
Only columns of type SMALLINT, INTEGER, BIGINT, DECIMAL, or NUMERIC can be created as identity columns.
0
0
DOUBLE A double-precision floating-point number is a long floating-point number of 64-bits. The range of double-precision floating-point numbers is approximately -7.2E+75 to 7.2E+75. In this range, the largest negative value is about -5.4E-79, and the smallest positive value is about 5.4E-79.
0
0