Review

3 4

Here are some questions to help you determine whether you have learned enough to move on to the next chapter. If you have difficulty answering these questions, review the material in this chapter before beginning the next chapter. The answers for these questions are located in the Appendix, "Questions and Answers."

1. Describe the difference in the ordering of data pages from a table caused by using either a clustered index or a nonclustered index.
2. Which recovery model does not require regular backups of the transaction log?
3. Why should you not create scripts that use Transact-SQL statements to directly query system tables?

Answers