IBM DB2 11.1 Advanced DBA for Linux, UNIX, and Windows — Question 48

What is the maximum precision for the DECIMAL data type?

Answer options

• A. 7
• B. 15
• C. 23
• D. 31

Correct answer: D

Explanation

The maximum precision for the DECIMAL data type is 31, allowing for a wide range of numerical values. Options A, B, and C represent lower precision levels that do not meet the requirements for applications needing high-precision calculations.