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

Chapter 13. Answers to Practice Exam 2

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

Question 1

Answer B is correct. The presence of a condition should not affect the addition of an index to the view. You must ensure that the WITH SCHEMABINDING option is performed when creating the view if you are going to be applying indexes. Because this preparatory step had not been completed, it needs to be done. WITH CHECK applies only to data modified through the view and ensures that when a row is modified through a view, the data remains visible through the view after the modification is committed. DROP EXISTING does not apply ...