Oracle OCP 082知识
剩余时间：
第 4 题 (多选题)：
Which two statements are true about a full outer join.
A. It returns matched and unmatched rows from both tables being joined .
B. It returns only unmatched rows from both tables being joined.
C. It includes rows that are returned by a Cartesian product.
D. The Oracle join operator (+)must be used on both sides of the join condition in the WHERE clause.
E. It includes rows that are returned by an inner join
显示答案
正确答案：
A,E
解析：
上一题
下一题
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