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

1. What is SQL Server 2000?
2. What language is commonly used to work with data in a database?
3. What is XML?
4. Which edition of SQL Server 2000 includes the complete SQL Server offering?
5. What is the purpose of the SQL Server 2000 relational database engine?
6. What SQL Server 2000 technology helps you build data warehouses and data marts in SQL Server by importing and transferring data from multiple heterogeneous sources?
7. What are at least four administrative tasks that you can use the SQL Server Enterprise Manager to perform?
8. Which tool is commonly used to create queries and execute them against SQL Server databases?
9. What are at least five objects that can be included in a logical database?
10. What are the major components involved in processing a SQL statement received from a SQL Server client?
11. What two roles does Microsoft Search play in supporting SQL Server?
12. What phases does a transaction go through?