DRAG DROP
You need to set up a database to provide a view of North American mammals.
Match the Structured Query Language (SQL) statements to the SQL query.
Instructions: To answer, drag the appropriate SQL statement from the column on the left to its place
in the SQL query on the right Each SQL statement may be used once, more than once, or not at all.
Each correct match is worth one point.

DRAG DROP
You have a database table that stores information about school attendance. You have a data set that
is defined as follows:

You have the following requirements:
StudentName must consist of a string of characters.
GradeLevel must be only a whole number.
DaysAbsent can have one number after the decimal.
Match the data types to the column names.
Instructions: To answer, drag the appropriate data type from the column on the left to its column
name on the right Each data type may be used once, more than once, or not at all. Each correct
match is worth one point.

HOTSPOT
Instructions: For each of the following statements, select Yes if the statement is true. Otherwise,
select No. Each correct selection is worth one point.

This question requires that you evaluate the underlined text to determine if it is correct.
In a database table, each column represents a unique record.
Instructions: Review the underlined text. If it makes the statement correct, select “No change is
needed.” If the statement is incorrect, select the answer choice that makes the statement correct

This question requires that you evaluate the underlined text to determine if it is correct. You have
two tables. Each table has three rows.
Nine rows will be included in the Cartesian product of these two tables.
Instructions: Review the underlined text. If it makes the statement correct, select “No change is
needed.” If the statement is incorrect, select the answer choice that makes the statement corrector.

You have two tables named Salesperson and Sales.
You need to ensure that each record in the Sales table has a valid associated salesperson record in
the Salesperson table.
Which database object should you add to the Sales table?

DRAG DROP
Your class project requires that you help a charity set up a website.
The website collects information about volunteers. Each volunteer record must be uniquely
identified. The following information is stored for each volunteer:
Given name Surname Date of birth Phone number Photo You need to create a table to meet the
requirements.
Match the Structured Query Language SQL statements to the SQL query.
Instructions:
To answer, drag the appropriate SQL statement from the column on the left to its place in the SQL
query on the right. Each SQL statement may be used once, more than once, or not at all. Each
correct match is worth one point.

This question requires that you evaluate the underlined text to determine if it is correct. Use the
ALTER statement to add a new table in a database.
Instructions: Review the underlined text. If it makes the statement correct, select “No change is
needed.” If the statement is incorrect, select the answer choice that makes the statement correct.

You need to rename a column in a database table.
Which data definition language (DDL) statement should you use?

DRAG DROP
You have two database tables as defined below. The first table contains information about students.
The second table contains information about courses. The two tables are related by CourseID.

Match the CourseName to the StudentName.
Instructions: To answer, drag the appropriate CourseName from the column on the left to its
StudentName on the right. Each CourseName may be used once, more than once, or not at all. Each
correct match is worth one point.