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

Chapter 17. Answer Key to Practice Test #2

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

Question 1

Answer F is correct. All queries are valid and none causes an error. Query A is a simple “get all columns from a table” query. B is similar except that it retrieves three specific columns. C references all columns by tables and schemas and a table’s by schemas, not causing an issue. D contains a schema name referencing the table, which incidentally does not have to ...