Which SET operator would you use to get the required output?

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?

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



Leave a Reply 1

Your email address will not be published. Required fields are marked *


alexy

alexy

Wouldn’t intersect also work? Assuming that CUST_HISTORY has the current city