When entering sales data into a database, you record the total price of items sold. If an item is sold for $19.99, which data type would be most appropriate to use for accuracy?
Floating-point number
Character
Boolean
Integer
The correct answer is 'Floating-point number' because this data type allows for the representation of non-integer numbers that include a decimal point. In our scenario, $19.99 cannot be accurately represented as an integer since it is not a whole number. Using an integer would result in loss of precision, as it would have to be rounded to either $19 or $20.
The other options are incorrect because 'Integer' does not allow for decimal precision, 'Boolean' is used for true/false values, and 'Character' is typically used for single letters or symbols, not numbers with decimals.
Bash is our AI bot, trained to help you pass your exam. AI Generated Content may display inaccurate information, always double-check anything important.
Join premium for unlimited access and more features
All plans include the following perks.
Our pricing is simple. Full access to all certifications and exams, for one price.
As many practice tests for as many topics as you want.
Use study mode non-stop, no limits.
No annoying ads and popups. Study without distractions.
Track your scores over time in study mode and report cards.
See how you improve over time, and where you need to focus.
Access our store with even more discounts than before.
Unlimited access to all PBQs and be prepared for the real thing.
Create an account or sign in to access our study materials.