CompTIA Tech+ (FC0-U71)Data and Database FundamentalsEasy
A technician is designing a Products table and needs a column to store the price of each item, which may include decimal values such as 19.99. Which data type is most appropriate for this field?
- ABoolean
- BText
- CDecimal
- DInteger
Show answer & explanationAnswer & explanation
Correct answer: C. Decimal
A decimal (or numeric) data type stores numbers with fractional precision, making it ideal for currency values like 19.99. Integer only stores whole numbers, Boolean stores true/false, and Text would prevent proper numeric calculations.
Why the other options are wrong
- A. Boolean only stores true/false values.
- B. Text would store the value as characters, preventing math operations.
- D. Integer cannot store fractional values like .99.
Column Data Types
A data type defines what kind of value a database column can hold, such as numbers, text, dates, or true/false values.
- Integer stores whole numbers only
- Decimal/Numeric stores fractional values with precision
- Choosing the wrong type can break calculations or waste storage
Memory trick: Decimal = dollars and cents need dots.