Oracle® 9i SQL Exam Cram™ 2 (Exam 1Z0-007)

Chapter 15. Answer Key to Practice Test #1

1.	B, E
2.	E
3.	B, C, E
4.	A, D
5.	A, B, C, D
6.	E
7.	E
8.	A
9.	A, B, C, D, E
10.	E
11.	A
12.	D
13.	A, C, E
14.	D
15.	A, B, C, D, E
16.	E
17.	C, D, E
18.	C, D, E
19.	D
20.	B, E
21.	C
22.	E
23.	C, E
24.	C, E
25.	B, D, E
26.	A, B
27.	E
28.	CREATE SESSION
29.	D
30.	E
31.	D
32.	A, B, E
33.	C
34.	D
35.	Hello World
36.	A
37.	D
38.	D
39.	F
40.	E
41.	E
42.	C
43.	E
44.	AsI
45.	E
46.	C
47.	D
48.	C
49.	A, B, C, D
50.	E
51.	E
52.	C
53.	A, B, C, D
54.	A, F, G, H
55.	A, D
56.	A, B, C
57.	B, D, F
58.	D, E
59.	A
60.	A

Question 1

Answers B and E are correct. A is invalid because a date cannot be summed up using SUM. B is correct because a maximum (MAX) value for a group of dates can be found. C is incorrect because aggregation functions cannot be applied in a WHERE clause because it filters rather than groups. D is incorrect because the ...