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?
A. LEFT OUTER JOIN with self join
B. self join
C. RIGHT OUTER JOIN with self join
D. FULL OUTER JOIN with self join
E. subquery
|
Download Printable PDF. VALID exam to help you PASS. |
 |
BE