Examine the description of the CUSTOMERS 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? (Choose two.)

Question

Examine the description of the CUSTOMERS 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? (Choose two.)

Accepted Answer

B. self join E. subquery

Answer

A. LEFT OUTER JOIN with self join

Answer

C. RIGHT OUTER JOIN with self join

Answer

D. FULL OUTER JOIN with self join

Examine the description of the CUSTOMERS 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…

Question

Exhibit

Options

How the community answered

Community Discussion