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. You create a local temporary stored procedure and ask a colleague to execute the stored procedure. Your colleague claims that she cannot execute the stored procedure. Why can't she execute the stored procedure?
2. Why do complex stored procedures typically execute faster the second time they are run than the first time?
3. What security features are available for stored procedures?
4. What function can you use to check the properties of a stored procedure and other objects in SQL Server?
5. Why is it more efficient to modify a stored procedure by using the ALTER PROCEDURE keywords than it is to drop and re-create a stored procedure?
6. You set the current database to Northwind, and then you create a stored procedure named #Procedure01. You then check the Northwind database for the stored procedure, but it doesn't appear. You can run the stored procedure using Northwind as the current database. Why are you able to execute this stored procedure but it doesn't appear in the Northwind database?
7. In what three ways is the RETURN statement used in a stored procedure?