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 the answers to these questions in Appendix A, "Questions and Answers."

1. What is a view?
2. What functions can a view be used to perform?
3. For what scenarios can views be used?
4. What are at least five restrictions that you must adhere to when creating views?
5. What two tools does SQL Server provide to create a view?
6. Where are the result sets stored for standard views and indexed views?
7. If a view is going to be indexed, what type of index must be the first index created on that view?
8. Which Transact-SQL statement or statements should you use to change the definition of a view or to delete that view from the database?
9. What Transact-SQL statement should you use if you want to view all of the data in the AuthorNames view of the Northwind database?
10. Which Transact-SQL statement or statements should you use to insert, modify, and delete data through a view?
11. What conditions must a view meet before you can modify data through that view?
12. When is a view considered to be an updateable partitioned view?