This question requires that you evaluate the underlined text to determine if it is correct.
Create a query that returns a set of table data by using the UPDATE statement.
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.

Your class project requires that you help a charity to create a website that registers volunteers.
The website must store the following data about the volunteers:
Given name Surname Telephone number Email address
You need to recommend a correct way to store the data.
What do you recommend?

This question requires that you evaluate the underlined text to determine if it is correct.
Truncate is a database term used to describe the process of applying a backup to a damaged or
corrupt 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 corrector.

This question requires that you evaluate the underlined text to determine if it is correct.
Use the ALLOW SELECT command to give a user permission to read the data in a table.
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

HOTSPOT
You have a user that has server roles as defined below:

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

The following illustration shows backup strategies that use the simple recovery model and the full
recovery model:

Instructions: Use the drop-down menus to select the answer choice that completes each statement.
Each correct selection 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.
Views are database objects that contain all of the data 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 have two tables named Cars and Color as defined below. The two tables are related by ColorId.

You run the following SQL statement: select:

How many rows does the SQL statement return?

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.
When volunteers ask to be removed from mailing lists, the table must be updated. You need to use a
transaction to ensure that the database has data integrity and referential integrity.
Which statement should you use?