O'Reilly logo

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

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

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

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 ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required