OCP-1Z0-051－６０

QUESTION NO: 60

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 current

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. INTERSECT

B. UNION ALL

C. MINUS

D. UNION

Answer: C（CUSTOMERS 中 减去改变过地址的CUST_HISTORY 的客户）

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/29876893/viewspace-1632412/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/29876893/viewspace-1632412/