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