WorksheetsDatabase Scenarios Review
Total questions: 10
Worksheet time: 6mins
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
