Oracle
1Z0-061 · Question #49
Examine the structure of the customers table: CUSTNO is the primary key in the table. You want to find out if any customers' details have been entered more than once using different CUSTNO, by…
The correct answer is A. Self-join B. Subquery. See the full explanation below for the reasoning.
Question
Examine the structure of the customers table:
CUSTNO is the primary key in the table. You want to find out if any customers' details have been entered more than once using different CUSTNO, by listing all the duplicate names. Which two methods can you use to get the required result?
Exhibit
Options
- ASelf-join
- BSubquery
- CFull outer-join with self-join
- DLeft outer-join with self-join
- ERight outer-join with self-join
How the community answered
(30 responses)- A73% (22)
- C3% (1)
- D17% (5)
- E7% (2)
Community Discussion
No community discussion yet for this question.