Workshop
These quiz questions are designed to test your knowledge of the material covered in this chapter.
Quiz
Which of the following SQL commands enables you to create new entries in a database table?
INSERT
ADD
CREATE NEW RECORD
UPDATE
Which portion of a SQL query is used to filter the number of records returned?.
Quiz Answers
a. The INSERT command enables you to add new records to a database table.
The WHERE portion of a SQL query uses an expression to filter the records returned by the query.
Exercise
Write SELECT, INSERT, UPDATE, and DELETE queries for the Customers table in the Northwind database. Verify that your queries work by running them in the Query Analyzer application (SQL Server only).