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. You are planning to deploy SQL Server 2000 to support Internet-based sales of your products. You need this installation to handle a large volume of transactions and be available 24x 7. Which edition of SQL Server 2000 should you choose?
2. You want to allow users to query SQL Server 2000 using their Internet browser via the Internet. What components of SQL Server 2000 are required?
3. The SQL Server 2000 database environment has a physical design component and a logical design component. As a database administrator, one of your tasks is to optimize the performance of SQL Server 2000. With respect to which type of database design do you have the most ability to affect performance?
4. You have an existing server application that uses SQL Server 2000 running on Windows 2000 servers. You have clients who access this server application using Windows 95 and Windows 98 client applications. You want to extend this server application to clients using an existing Novell network. What type of authentication decisions must you make?

Answers