Multiple choices 18/50
(Choose 1 answer)
R
S
T
Here are three relations, R(A,B), S(C.D).and T(E.F). (see figure)
F
Compute the result of the query:
SELECT A. F. SUM(C). SUM(D)FROM R, S, T WHERE B = C AND D = E GROUP BY A, F HAVING COUNT(*) > 1
0
1
0
1
0
1
1
0
1
0
1
0
Identify, in the list below, the row that appears in the result.
1
1
1
1
1
1
Next
A. (1.1.1.1)
B. (1,1,2,2)
C. None of the others
D. (1.1.2.1)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16 17
18
19
20
21
22
23
24
25
26 27
28
29
30
31
32
33
34
35
36
37
38
39
40 41 47
43
44
45 46 47 48
49 50
