Database Scenarios Review

Marty, a database administrator, has added a foreign key to a table in a database. Which of the following describes the purpose of a foreign key?

• To allow the storage of unstructured data.

• For one table to reference records in another table.

• To provide a way to distinguish records within a table.

• For one database to reference another database.

A business wants to set up a database to store customer and order information. They have decided to use a relational database. Which of the following is the main benefit of using a relational database?

• The data can be organized into separate tables that are related to each other.

• The data can be stored as unstructured data.

• The data can be saved as a flat file.

• The data is stored as a single file for quick retrieval.

A database administrator is setting up a new table that will contain customer information. The fields include name, address, company, phone, email, and customer ID. The administrator is using the customer ID to uniquely identify each customer record. Which of the following BEST describes the customer ID field?

• Public key

• Foreign key

• Primary key

• Private key

Which of the following should NOT be used as a primary key in a table?

• First name

• Username

• Social Security number

• Employee ID

The Weather Channel is looking to assess their data on last year's hurricane season. Which type of data would they be analyzing?

• Operational

• Analytical

• Attributes

• Hypotheticals

This is an image of a table in a database. The header at the top of the column (ID, First Name, Last Name, etc.) is also known as what?

• Field

• Record

• Entity

• Table

Joe would like to change/manipulate all the records in a customers table. Which type of data language would he use?

• Data Definition Language

• Data

• Data Manipulation Language

• Operational

John is looking to alter the schema of the database. Which data language would he most likely use?

• Data Defined Language

• DML

• Analytical

• Operational

A company is looking to store their data based on their everyday operations. Which data type would this refer to?

• Tables

• Historical Data

• Analytical Data

• Operational Data

There are several table relationships when creating databases. The example of one building to several classrooms is known as?

• One-to-One

• One-to-Many

• Many-to-Many

• No Relationship