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 want to create a user database containing multiple data files on separate physical disks. You are not experienced at writing Transact-SQL statements. What is the simplest method you can use to create this database?
2. Describe the two methods you can use to change the database recovery model for a database.
3. You created a new database on your system. You used the default properties for the transaction log file. You backed up the new database and the master database. After you performed a bulk load of data into your new database, you notice that the transaction log is quite large. Why did it grow so large and what must you do to reduce the size of the transaction log?
4. You are managing a small database system running on Windows 2000 Server. Although the database is under 1 GB in space, it is very busy (primarily performing writes), and you want to improve its performance. You do not have the budget for a hardware RAID system and are not aware of specific database access patterns. You have already placed the transaction log file on a separate disk from the data file. What is an inexpensive solution?

Answers