Database Fundamentals — Question 33

You need to store product quantities, and you want to minimize the amount of storage space that is used. Which data type should you use?

Answer options

• A. INTEGER
• B. DOUBLE
• C. COUNT
• D. FLOAT

Correct answer: A

Explanation

The INTEGER data type is the most efficient for storing whole numbers like product quantities, as it uses less storage space compared to DOUBLE and FLOAT, which are designed for decimal values. COUNT is not a standard data type but rather a function or operation, making it unsuitable for this purpose.