Chapter 10. Practice Exam 1

The actual certification exam has 40 questions. To best simulate the exam circumstances, you should try to complete the 40 questions in this practice exam in 90 minutes.

Chapter 11, “Answers to Practice Exam 1,” provides the answers to this practice exam. Each answer is accompanied by references to the applicable materials in SQL Server 2005 Books Online and on the Microsoft official websites.

Exam Questions


You are creating a database that will store sales order information. Orders will be entered in a client/server application and over the Internet via an ASP.NET application. Each time a new order is placed in the system, a unique order number must be assigned, and the order numbers must be in ascending sequence. It ...

Get MCTS 70-431: Implementing and Maintaining Microsoft SQL Server 2005 now with O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.