14. Examine the description of the SATES1 table
SALES2 is a table with the same description as SALES1
Some sales data is contained erroneously in both tables
You must display rows from SALES1 and SALES2 and wish to see the duplicates too
Which set operator generates the required output?
A.MINUS
B.UNION ALL
C.SUBTRACT
D. UNION
E. INTERSECT
参考答案：E
解析：
SALES2是一个与SALES1描述相同的表
两个表中都错误地包含了一些销售数据
您必须显示来自SAlES1和SALES2的行，并且还希望看到重复的行
哪个集合操作符生成所需的输出?
duplicates 是重复的意思，重复就是取交集，选E