OCP-1Z0-051 第151题 集合操作

一、原题

View the Exhibit and examine the structure of the CUSTOMERS and CUST_HISTORY tables.

The CUSTOMERS table contains the current location of all currently active customers. The CUST_HISTORY table stores historical details relating to any changes in the location of all currently as well as previous customers who are no longer active with the company.
You need to find those customers who have never changed their address.
Which SET operator would you use to get the required output?
A. MINUS
B. UNION
C. INTERSECT
D. UNION ALL

答案：A

二、题目翻译

查看CUSTOMERS and CUST_HISTORY的表结构：
CUSTOMERS表包含所有当前活动客户的位置,CUST_HISTORY表存储相关的所有当前位置的改变的历史信息和公司中先前不再活动的客户。
要找到那些从来没有改变过地址的客户.
哪一个集合操作给出所需结果。

三、题目解析

一个表中是活动客户的地址信息，一个表中是客户以前地址的历史信息，两张表的差集，就是从来没有改变过地址的客户。