Updating a Table › Review

Review

Choose the correct answers for the questions below. More than one answer can apply for each question.

1. You use a SELECT statement with INSERT to:
   1. Copy specific rows from one table to another
   2. Add a completely new row to a database
   3. Modify a row in a table
2. If you don't have a value for every column you are adding to a table, you can:
   1. Identify only the columns you are going to insert values into
   2. Use the keyword NULL for the columns where the value is unknown
   3. Use two quotes with a space between for the columns where the value is unknown
3. You can update all rows in a table by:
   1. Using a WHERE clause with an *
   2. Omitting the WHERE clause
   3. Using an * after the keyword UPDATE
4. You can update selected rows in a table by:
   1. Specifying columns after the keyword UPDATE
   2. Using a WHERE clause with an *
   3. Specifying a search condition in a WHERE clause
5. You are updating all columns in a table but do not know the specific value to put into one column. You can:
   1. Use the keyword UNKNOWN for the column where the value is unknown
   2. Use two quotes with a space between for the column where the value is unknown
   3. Use the keyword NULL for the column where the value is unknown
6. If you do not have a WHERE clause in a DELETE statement:
   1. All the rows are deleted and the table is deleted as well
   2. The table is deleted
   3. All the rows are deleted but the table remains

To check your answers, see Review Answers for Chapter 8.