Oracle OCP 082知识
剩余时间:
第 3 题 (多选题):
Which three statements are true regarding the UNION and UNION ALL operators.
A. The number of columns selected by the first SELECT statement can be greater than the number selected in subsequent SELECT statements.
B. Duplicates are eliminated automatically by the UNION ALL operator.
C. The number of columns selected in each SELECT statement must be identical .
D. NULLS are not ignored during duplicate checking.
E. The names of columns selected in each SELECT statement must be identical.
F. The names of columns selected in each SELECT statement can be identical .
G. Duplicates can optionally be eliminated by the UNION operator
显示答案
正确答案:
C,D,F
解析:
上一题
下一题
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
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80