You have a table that contains product IDs and product names.
You need to write an UPDATE statement to change the name of a specific product to glass.
What should you include in the update statement?

Your database contains a table named Customer.
You need to delete the record from the Customer table that has a CusromerID of 12345. Which
statement should you use?

On which database structure does an insert statement operate?

You have a table of products with fields for ProductID, Name, and Price.
You need to write an UPDATE statement that sets the value in the InStock field to Yes for a specific
ProductID.
Which clause should you use in your update statement?

You have the following table definition:
CREATE TABLE Product (ProductID INTEGER, Name VARCHAR(20))
You need to insert a new product. The product’s name is Plate and the product’s ID is 12345.
Which statement should you use?

You have the database table named Cars as defined below: You have the following Structured Query
Language (SQL) statement:

How many rows are returned by the SQL statement?

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.

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.

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?