1Z0-071 Web TestEngine demo

Examine the description of the CUSTONERS table:

CUSTNO is the PRIMARY KEY.

You must determine if any customers' details have been entered more than once using a different CUSTNO, by listing all duplicate names.

Which two methods can you use to get the required result?

Select all that apply.

• A

  LEFT OUTER JOIN with self join

• B

  PULL OUTER JOIN with self join

• C

  subquery

• D

  RIGHT OUTER JOIN with self join

• E

  self Join