You have a database table named SongInformation as defined below:

You need to create a Structured Query Language (SQL) query to retrieve only the names of songs
that sold more than 1000 compact discs (CDs).
Which query should you use?

You accept an IT internship at a local charity. The charity asks you to keep a record of its volunteers
by using a database table named Volunteer.
The table has the following columns and rows:

When volunteer information changes, you must update the table. You need to change Tia’s name to
Kimberly. Which statement should you choose?

This question requires that you evaluate the underlined text to determine if it is correct.
Use the FROM keyword in a SELECT statement to return rows that meet a specific condition.
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 combine the results of two queries into a single result that contains all of the rows from
both queries.
Which Structured Query Language (SQL) statement should you use?

This question requires that you evaluate the underlined text to determine if it is correct.
The CREATE TABLE command removes one or more table definitions and all data, indexes, triggers,
constraints, and permission specifications for those 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 correct

You accept an IT internship at a local charity. The charity wants you to help them with compliance
and auditing requirements.
You need to ensure that a column or combination of columns uniquely identifies each row of a table.
Which constraint should you define?

While attending college, you accept an IT internship at a local charity. The charity needs to report on
data that is related and exists in two tables.
You need to establish a relationship between the data that is in the two tables.
Which constraint should you define?

HOTSPOT
The following illustration shows the structure of a clustered index in a single partition:

Instructions: Use the drop-down menus to select the answer choice that completes each statement
Each correct selection is worth one point.

HOTSPOT
You have the following table:

Instructions: Use the drop-down menus to select the answer choice that completes each statement.
Each correct selection is worth one point.

This question requires that you evaluate the underlined text to determine if it is correct.
A view can be used to ensure referential integrity.

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