Question 790
A billing SQL database stores exact tax and invoice amounts and repeated floating-point rounding causes mismatched totals. The team is considering this step: Change the audited schema and expressions to DECIMAL(p,s) with appropriate rounding policy. What evidence should they review before proceeding?
Explanation
Correct Answer
Compare maximum amount, decimal places, type conversions and calculation paths. DECIMAL with explicit precision and scale is more suitable for fixed-precision financial arithmetic than FLOAT. Recalculated invoices meet cent-level acceptance tests and boundary values fit.
Incorrect Answers
Binary floating-point representation and display formatting cannot guarantee fixed-decimal financial arithmetic.
DECIMAL is appropriate only with selected precision, scale and reviewed intermediate arithmetic and rounding rules.
Fixed-point storage must be paired with valid formulas, explicit conversions, and boundary-condition reconciliation.