1Z0-082 Web TestEngine demo

Examine the description of the CUSTOMERS table:

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

Which two methods can you use to get the required result? (Choose two.)

Select all that apply.

• A

  subquery

• B

  self join

• C

  LEFT OUTER JOIN with self join

• D

  RIGHT OUTER JOIN With self join

• E

  FULL OUTER JOIN with self join