A MySQL database includes a CUSTOMER table, which stores each customer's current balance in U.S. dollars and cents, among other information. The correct data type for the BALANCE column in the CUSTOMER table is _____.
A) CHAR
B) INT
C) SMALLINT
D) DECIMAL

Question

Quizplus · Accepted Answer

DECIMAL is the appropriate data type for storing monetary values like a customer's balance in a database because it can accurately represent fixed-point numbers, which are necessary for financial calculations to avoid rounding errors that can occur with floating-point types.

A MySQL Database Includes a CUSTOMER Table, Which Stores Each