HOTSPOT
The following graphic shows the components of a SQL Server application. You access the SQL Server application through Internet Explorer.

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

Solution:


Does this meet the goal?

Correct Answer:A

Which command should you use to add a column to an existing table?

Correct Answer:B

You are writing a select statement to find every product whose name contains a specific character.
Which keyword should you use in your where clause?

Correct Answer:D

One reason to add an index is to:

Correct Answer:C

A database contains two tables named Customer and Order. You execute the following statement:
DELETE FROM Order
WHERE CustomerID = 209
What is the result?

Correct Answer:C

Which category of SQL statements is used to add, remove, and modify database structures?

Correct Answer:D