The correct data type for the BALANCE column in the CUSTOMER table is ____.
A)CHAR
B)INT
C)SMALLINT
D)DECIMAL

Question

The correct data type for the BALANCE column in the CUSTOMER table is ____.​
A)CHAR
B)​INT
C)SMALLINT
D)​DECIMAL

Quizplus · Accepted Answer

The BALANCE column in the CUSTOMER table should be represented using the DECIMAL data type as it involves numerical values with decimal points, such as currency or monetary values. The DECIMAL data type is used to represent exact decimal numbers and is suitable for storing financial data where precision is crucial.

The Correct Data Type for the BALANCE Column in the CUSTOMER