Database Concepts Quiz

What is a database program used for?

• Writing documents

• Organizing and retrieving information

• Creating graphics

• Browsing the internet

A table in a database consists of:

• Images and text

• Columns and rows

• Only numbers

• Only text

A record in a database represents:

• A collection of unrelated data

• A single piece of information

• Information related to one entity

• A random assortment of fields

What is a field in a database?

• A type of record

• A discrete chunk of information

• A column with only numerical data

• A database program

The primary key in a database:

• Can be duplicated

• Uniquely identifies each row

• Is optional

• Must always contain numbers

A foreign key:

• References a primary key in another table

• Is used to delete tables

• Can only contain unique values

• Cannot store numerical values

A database relationship is established by:

• Using foreign keys

• Adding duplicate records

• Deleting tables

• Changing field names

A one-to-many relationship means:

• Each record in table A can have many matching records in table B

• Each record in table B can have many matching records in table A

• Each table has only one record

• There is no relationship between tables

What is a junction table used for?

• Storing unrelated data

• Connecting two tables in a many-to-many relationship

• Eliminating relationships between tables

• Deleting redundant records

In a one-to-one relationship:

• One record in table A has at most one matching record in table B

• A record in table A can have multiple matches in table B

• Tables do not need relationships

• It is not commonly used in databases