Oracle
1Z0-071 · Question #148
Examine the structure of the CUSTOMERS table: (Choose two.) CUSTNO is the PRIMARY KEY. You must determine if any customers' details have been entered more than once using a different CUSTNO, by…
The correct answer is A. Subquery B. Self-join. See the full explanation below for the reasoning.
Question
Examine the structure of the CUSTOMERS table: (Choose two.) 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?
Exhibit
Options
- ASubquery
- BSelf-join
- CFull outer-join with self-join
- DLeft outer-join with self-join
- ERight outer-join with self-join
How the community answered
(58 responses)- A84% (49)
- C9% (5)
- D2% (1)
- E5% (3)
Community Discussion
No community discussion yet for this question.