nerdexam
Oracle

1Z0-071 · Question #164

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…

The correct answer is C. MINUS. See the full explanation below for the reasoning.

Question

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?

Exhibit

1Z0-071 question #164 exhibit

Options

  • AINTERSECT
  • BUNION ALL
  • CMINUS
  • DUNION

How the community answered

(35 responses)
  • A
    3% (1)
  • B
    6% (2)
  • C
    77% (27)
  • D
    14% (5)

Community Discussion

No community discussion yet for this question.

Full 1Z0-071 Practice