Examine the structure of the CUSTOMERS table: (Choose two.)
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. Subquery
B. Self-join
C. Full outer-join with self-join
D. Left outer-join with self-join
E. Rightouter-join with self-join
|
Download Printable PDF. VALID exam to help you PASS. |
 |