Review

[Previous] [Next]

The following questions are intended to reinforce key information presented in the 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. You have a SQL Server 6.5 database running on a Windows NT Server. Both SQL Server and Windows NT Server have Service Pack 2 installed. The size of the tempdb database on SQL Server 6.5 is 8 MB. After installing SQL Server 7 on the same computer, there is 100 MB of free disk space. The size of the SQL Server 6.5 database you want to upgrade is 90 MB. What must you do in order to upgrade this database?

Answer

2. During the upgrade process, the SQL Server Upgrade Wizard cannot upgrade a stored procedure in the SQL Server 6.5 user databases. What could cause this failure?

Answer

3. You just upgraded a credit card database to SQL Server 7, and you have a client application that contains the following query:

 SELECT ;t.title ;AS ;cross
 FROM ;titles ;t 

You want to use the BACKUP and RESTORE commands as part of maintenance jobs that you create. To allow these commands, you set the database compatibility level to 70. What impact does this setting have on your application?

Answer