Which data type is best suited to store a person's age in a database?
Think about what kind of values age represents: whole numbers, yes or no, or dates?
Age is a whole number without fractions, so an integer type is best to store it efficiently and accurately.
Which data type is used to represent answers like 'yes' or 'no' in data planning?
Consider the simplest data type that can hold only two states.
Boolean data type stores two possible values: true or false, which correspond to yes or no answers.
You want to store the date when a user signed up for a service. Which data type should you choose?
Think about the data type that can handle day, month, and year information.
Date/Time data type is designed to store dates and times, allowing easy sorting and calculations.
Which data type is most appropriate for storing product prices that can have cents (like $19.99)?
Consider data types that can store numbers with decimals.
Floating point numbers can store decimal values, which are necessary for prices including cents.
A field in a form can contain either a number or the word 'unknown'. Which data type should be planned for this field?
Think about a data type that can hold both words and numbers as text.
Since the field can contain words or numbers, using a text/string type allows storing both without errors.