Home > Articles

A Crash Course

  • Print
  • + Share This
This chapter is from the book

Workshop

These quiz questions are designed to test your knowledge of the material covered in this chapter.

Quiz

  1. Which of the following SQL commands enables you to create new entries in a database table?

    1. INSERT

    2. ADD

    3. CREATE NEW RECORD

    4. UPDATE

  2. Which portion of a SQL query is used to filter the number of records returned?.

Quiz Answers

  1. a. The INSERT command enables you to add new records to a database table.

  2. 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).

  • + Share This
  • 🔖 Save To Your Account