These quiz questions are designed to test your knowledge of the material covered in this chapter.
Which of the following SQL commands enables you to create new entries in a database table?
CREATE NEW RECORD
Which portion of a SQL query is used to filter the number of records returned?.
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.
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).