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

1. In which window in SQL Query Analyzer can you enter and execute Transact-SQL statements?
2. How do you execute Transact-SQL statements and scripts in SQL Query Analyzer?
3. What type of information is displayed on the Execution Plan tab, the Trace tab, and the Statistics tab?
4. Which tool in SQL Query Analyzer enables you to control and monitor the execution of stored procedures?
5. What is Transact-SQL?
6. What are the three types of Transact-SQL statements that SQL Server supports?
7. What type of Transact-SQL statement is the CREATE TABLE statement?
8. What Transact-SQL element is an object in batches and scripts that can hold a data value?
9. Which Transact-SQL statements do you use to create, modify, and delete a user-defined function?
10. What are control-of-flow language elements?
11. What are some of the methods that SQL Server 2000 supports for executing Transact-SQL statements?
12. What are the differences among batches, stored procedures, and triggers?