Database Fundamentals Quiz1

Ishmael is working on a project for school. What is the main purpose of a database?

• To store and organize data

• To create computer games

• To browse the internet

• To calculate math problems

Answer explanation

The main purpose of a database is to store and organize data efficiently, allowing for easy retrieval and management. This is essential for various applications, unlike the other options which do not relate to databases.

In a school database, which of the following is an example of a field name that might be used to store student information?

• "Aiden"

• "Date of Birth"

• "123456"

• "Blue"

Answer explanation

"Date of Birth" is a field name that clearly indicates it will store a specific type of student information, namely the date when a student was born. The other options are not suitable field names.

In database terminology, a "record" refers to:

• A type of music album

• A single row of data in a table

• A list of all the fields

• A software program

Answer explanation

In database terminology, a "record" specifically refers to a single row of data in a table, which contains related information about an entity. The other options do not accurately describe this concept.

Kaneal is organizing a database for her school project. What is a "Primary Key"?

• The key to open a locked database

• A special field that uniquely identifies a record

• A password for accessing a database

• A field where all the data is stored

Answer explanation

A 'Primary Key' is a special field in a database that uniquely identifies each record, ensuring that no two records have the same key. This is crucial for maintaining data integrity and efficient data retrieval.

What type of information is best stored in a database?

• Random thoughts

• Organized data like customer orders or student grades

• Images and music files only

• Messages from social media

Answer explanation

Databases are designed to store organized data efficiently. Customer orders and student grades are structured information that can be easily queried and managed, making them ideal for database storage.

Kaley_On is trying to create a new database for her school project. Which view should she use to set up the structure of a database table?

• Datasheet View

• Design View

• Table View

• Layout View

Answer explanation

Garena should use Design View to set up the structure of a database table. This view allows her to define fields, data types, and relationships, which is essential for creating a well-structured database.

In a class project, Nathan is trying to categorize different types of data he collected. Which of these is an example of a data type in a database?

• Blue

• Text

• Triangle

• Fiction

Answer explanation

In databases, data types define the kind of data that can be stored. 'Text' is a common data type used to store alphanumeric characters, making it the correct choice. The other options do not represent standard data types.

What happens when Etana assigns a "Primary Key" to a field?

• It plays music when clicked

• It prevents duplicate values in that field

• It deletes all the data in the table

• It changes the field color to green

Answer explanation

Assigning a 'Primary Key' to a field ensures that all values in that field are unique, preventing any duplicate entries. This is crucial for maintaining data integrity in a database.

Why is it important for a Primary Key field to have no null values in Shara's student database?

• To keep the database looking neat

• To ensure each record is unique

• To make the database faster

• To save storage space

Answer explanation

A Primary Key must have no null values to ensure each record is unique. This uniqueness is crucial for identifying records distinctly, preventing data duplication and maintaining data integrity in Abigoula's student database.

In a school database, Tishora wants to find out which students scored above 90% in their exams. What is the role of a "Query" in this database?

• To decorate the database

• To ask questions and retrieve specific data

• To delete all the records

• To add new rows to a table

Answer explanation

A 'Query' in a database is used to ask questions and retrieve specific data, such as finding students who scored above 90%. This makes it the correct choice, as it directly relates to Chelsea's goal.