Database Concepts Quiz

A ??? database is a database that contains a single table.

• Flat file

• Relational

• Hierarchical

• Network

Keeping the database as a flat file database would cause issues with inconsistency and data ???.

• Redundancy

• Integrity

• Security

• Accuracy

A ??? database contains more than one table. The data in the tables are linked using relationships.

• Relational

• Flat file

• Hierarchical

• Network

A ??? contains the data for one object, person, or place.

• Record

• Table

• Field

• Database

A ??? holds a collection of records for a particular theme.

• Table

• Field

• Database

• Record

These are the categories for each piece of data in the table.

• Field

• Record

• Table

• Database

A primary key is used to give each record a unique ???.

• Code

• Field

• Table

• Record

When you link to a source table’s primary key you use a ???.

• Foreign key

• Primary key

• Field

• Record

What does SQL stand for?

• Structured Query Language

• Simple Query Language

• Standard Query Language

• Sequential Query Language

What is SQL primarily used for?

• Communicating with a database

• Designing web pages

• Creating graphics

• Writing operating systems