🎴 Flashcard Mode
DB2 Database Fundamentals
Card1 / 15
Mastered0
Review0
QuestionClick to flip
Given the following scenario: Table TABLE1 needs to hold specific numeric values up to 9999999.999 in column COL1. Once TABLE1 is populated, arithmetic operations will be performed on data stored in col-umn COL1. Which of the following would be the most appropriate DB2 data type to use for column COL1?
AnswerClick to flip back
A
DECIMAL(10,3)
💡 Explanation:
To store values up to 9999999.999, you need 7 digits before the decimal point and 3 digits after, requiring a total precision of 10. Thus, DECIMAL(10,3) is the correct data type.