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 concerned about keeping the data stored within your SQL Server 2000 installation extremely secure. All of the users who will access this data are Windows 2000 users. Should you permit SQL Server authentication? Why or why not?
2. A member of the help desk staff has complained that although she can log on to SQL Server 2000 and access the Northwind and Pubs databases, she cannot even see the Northwind Reports database. How is this possible?
3. You are creating a new SQL Server 2000 installation. Hundreds of users will require access to several different databases on this SQL Server 2000 instance. Should you use SQL Server Enterprise Manager or Transact-SQL system stored procedures for creating these login and user accounts? Why?

Answers