CompTIA Data+ DA0-002 (V2) Practice Question

DECIMAL (also called NUMERIC) is a fixed-point, exact numeric data type. Its precision (total digits) and scale (digits after the decimal point) are defined by the developer, so values are stored exactly as written. Database vendors-including MySQL and SQL Server-explicitly recommend DECIMAL/NUMERIC for monetary or other calculations that cannot tolerate rounding error. FLOAT and DOUBLE PRECISION are approximate binary floating-point types; they represent many decimal fractions only approximately and can introduce subtle errors when summed or multiplied. INTEGER stores only whole numbers, so it cannot represent cents. Therefore, DECIMAL(p,s) is the only option that meets the requirement for exact two-decimal-place currency values.