Database Concepts Quiz

Which of the following best describes a database?

• A collection of paper files stored in cabinets

• A digital collection of organized data

• A folder containing Word documents

• A storage device for software

What is a table in the context of databases?

• A collection of data that stores information

• A language used for developing and managing Web databases

• Options unique to each tab in Access

• Menus such as Home, Create, External Data, and Database Tools

In a database, what are tables used for?

• To store unrelated data

• To store related data in rows and columns1

• To create charts and graphs

• To store pictures and videos

What does a record (or row) in a database table represent?

• A calculation used

• A unique identifier

• A collection of data for one item or person

• A specific name

What is a record in a database?

• A unique ID that identifies an entry

• A column in a database table

• A collection of related data about a particular item or entity

• A row in a database table

 Robert needs to create a database of all his friends. In a table, is what last name considered?   

•  Field
•   Record
•  Table
•   Cell Address

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

• To store the main information about the database

• To create relationships between tables

• To uniquely identify each record in a table2

• To sort the information in the table