Review

3 4

The following questions are intended to reinforce key information presented in this chapter. If you are unable to answer a question, review the appropriate lesson and then try the question again. You can find answers to the questions in Appendix A, "Questions and Answers."

1. What are the four primary properties that most SELECT statements describe in a result set?
2. What are the main clauses of a SELECT statement?
3. What are several keywords that you can use in a select list?
4. What type of objects can you specify in the FROM clause of a SELECT statement?
5. What purpose does a join provide when used in a SELECT statement?
6. What are the differences between inner joins and outer joins?
7. What is a subquery?
8. What are the differences between a CUBE operator and a ROLLUP operator?
9. For what types of columns can you not specify values in an INSERT statement?
10. What methods can you use to modify data in a SQL Server database?
11. What are the major clauses contained in an UPDATE statement?
12. Which statement should you use to delete all rows in a table without having the action logged?