MCTS 70-431: Implementing and Maintaining Microsoft SQL Server 2005

Chapter 11. Answers to Practice Exam 1

1.	B
2.	A, E
3.	A
4.	A, B
5.	D
6.	C
7.	B, C
8.	E
9.	D, E
10.	D
11.	A, B, C
12.	D
13.	D
14.	C
15.	E
16.	A
17.	C
18.	C
19.	B
20.	A
21.	C
22.	D
23.	B, C, F
24.	A, C, E
25.	A, C
26.	B
27.	A
28.	A
29.	E
30.	C
31.	D
32.	C
33.	E
34.	E
35.	B
36.	D
37.	C
38.	C, D
39.	A, D
40.	A, E

Question 1

Answer B is correct. An Integer data type of one form or another would be the correct choice for the type for the order number. The size of integer used would be determined based on the total number of orders maintained in the table over time. By the looks of the volume being discussed, it may even be worth considering an Alphanumeric data type. Small and Tiny integers would be out of the question because they don’t provide for a size large enough to even hold a week’s worth of data. Using an IDENTITY column ...