Free SQL Server Certification Quiz

Q 1.) SQL Server 2000 can have up to .... simultaneous instances?

A. 1
B. 2
C. 5
D. 8
E. 16

Q 2.) What are the downsides of upgrading a SQL Server to SQL Server 2000?

A. Possible upgrade problems
B. Possible hardware/performance problems
C. No way of reversing the upgrade
D. All of the above
E. Both A and C are correct

Q 3.) You upgrade your SQL Server 6.5 database to SQL Server 2000. Your application which connects to the server is experiencing problems with NULL values being allowed. What should you do?

A. Get the application developer to rewrite the application
B. Set the column rules to not allow NULL values
C. Switch back to your SQL Server 6.5 box
D. Insist users make sure they enter all the data required

Q 4.) The MS Query tool is used for querying databases via....

A. SQL Server client tools
B. Office 97
C. Office 2000
D. Both A and B are correct
E. Both B and C are correct

Q 5.) What Transact-SQL stored procedure will detach a database?

A. sp_remove_db
B. sp_detach_db
C. sp_detachdb
D. DBCC DETACHDB
E. DBCC DETACHDATABASE