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 have decided to install SQL Server 2000 on a test computer to evaluate the new features available. You have a Pentium III 400-MHz laptop with 96 MB of memory. Will this laptop be sufficient for testing the new features of SQL Server 2000?
2. You are installing SQL Server 2000. You want SQL Server 2000 to be able to use your Microsoft Exchange Server to notify you when jobs succeed or fail. What type of account should you use for the SQL Server and SQL Server Agent services?
3. You are installing SQL Server 2000. You have a mixed network of computers including Windows NT servers and Novell servers. Your network supports both TCP/IP and NWLink IPX/SPX. Should you perform a typical or a Custom setup?
4. You are installing SQL Server 2000. You have heard that SQL Server 2000 allows you to install SQL Server 2000 side by side with SQL Server 7.0. If you install SQL Server 2000 as a named instance, what issues should you be aware of?
5. You are installing SQL Server 2000. You plan to install identical configurations on multiple computers to test the configuration's performance on different hardware platforms. You do not want to click your way through the SQL Server 2000 interactive Setup program each time you install SQL Server 2000. What should you do?
6. You have installed SQL Server 2000 on a test computer for evaluation. You had a problem initially starting the SQL Server service due to a logon failure. You solved the problem. You want to review the SQL Server error log related to the failure to start the SQL Server service. Can you do this, and if so, how?

Answers