Database Basics Quiz

What is the main purpose of a database?

• To create animations

• To store and manage data

• To browse the internet

• To edit images

Which field type is best used for storing website links in a database?

• Image

• Hyperlink

• Video

• Sound

What is the purpose of a primary key in a table?

• To store images

• To uniquely identify records

• To calculate values

• To delete duplicate records

What is a table in a database?

• A collection of records

• A list of queries

• A formatting tool

• A document editor

What is the main function of a query in a database?

• Delete data permanently

• Retrieve specific information from a database

• Format database text

• Store images

What is a range query used for?

• Selects records greater than a value

• Selects records within a range of values

• Deletes duplicate values

• Sorts records alphabetically

Which database object allows users to enter and modify data in a user-friendly way?

• Report

• Query

• Table

• Form

What is the purpose of a foreign key in a database?

• Link two tables together

• Store unique values

• Create a backup of a database

• Delete unwanted records

In database terminology, what does a record represent?

• A column of data

• A row of data

• The entire database

• A single character of data

In which view can you design and modify a query in MS Access?

• Datasheet View

• Form View

• Query Design View

• Report View