Database Basics Quiz

Which of the following data types is most suitable for storing a person's email address in a database?

• Number

• Short Text

• Yes/No

• Data

Answer explanation

Short Text data type is most suitable for storing a person's email address in a database as it allows for the necessary characters and format of an email address.

What is a primary reason for using databases in software applications?

• To increase the processing speed of the application

• To store, retrieve, and manage data efficiently

• To improve the graphical interface of the application

• To reduce the cost of software development

Answer explanation

Using databases in software applications is primarily for storing, retrieving, and managing data efficiently, making data access and manipulation more streamlined and organized.

Which of the following is NOT a good naming convention for database tables?

• Using clear and descriptive names

• Using abbreviations to shorten the names

• Using singular nouns

• Avoiding the use of spaces and special characters

Answer explanation

Using abbreviations to shorten the names is NOT a good naming convention for database tables as it can lead to confusion and make the table names less descriptive.

In databases, what data type should be used to store a monetary value, for example how much a soft drink costs?

• Short Text

• Date

• Number

• Yes/No

Answer explanation

The correct data type to store a monetary value in databases is 'Number' as it allows for accurate representation of decimal values for prices.

Which of the following is a common application of databases in software?

• Storing user preferences in a mobile app

• Generating 3D graphics in video games

• Processing real-time audio signals

• Enhancing the performance of the computer's CPU

Answer explanation

Storing user preferences in a mobile app is a common application of databases in software, allowing for efficient data storage and retrieval for personalized user experiences.

What is the best practice for naming a field that stores the date of birth of a user?

• userDOB

• date_of_birth

• UserDateOfBirth

• dob

Answer explanation

The best practice for naming a field that stores the date of birth of a user is 'date_of_birth' as it is clear, descriptive, and follows a standard naming convention.

Which of the following data types is best suited for storing a user's age?

• Short Text

• Number

• Date

• Yes/No

Answer explanation

The best data type for storing a user's age is 'Date' as it accurately represents a person's age and allows for easy calculations and comparisons.

What is a key benefit of using relational databases in applications?

• They support complex graphical interfaces.

• They can store data without any structure.

• They facilitate easy data retrieval through relationships.

• They automatically encrypt all stored data.

Answer explanation

Relational databases facilitate easy data retrieval through relationships, allowing for efficient querying and data manipulation.

Which of the following is NOT a recommended practice for naming database tables?

• Using plural nouns

• Prefixing names with the application name

• Keeping names short and simple

• Using uppercase for all letters

Answer explanation

Using uppercase for all letters is NOT a recommended practice for naming database tables as it can make the names harder to read and maintain.

For storing a flag that indicates whether a user's email has been verified, which data type should be used?

• Short Test

• Yes/No

• Number

• Date

Answer explanation

The correct data type to store a flag indicating email verification status is Yes/No as it directly represents the binary nature of the verification status.