Exam 1z0-071 Topic 14 Question 180 Discussion

Actual exam question for Oracle's 1z0-071 exam
Question #: 180
Topic #: 14
Examine the description of the CUSTONERS table

CUSTON is the PRIMARY KEY.
You must derermine if any customers'derails have entered more than once using a different costno,by listing duplicate name Which two methode can you use to get the requlred resuit?

Suggested Answer: C,D Vote an answer

To determine if customer details have been entered more than once using a different custno, the following methods can be used:
SUBQUERY: A subquery can be used to find duplicate names by grouping the names and having a count greater than one.
SELECT custname FROM customers GROUP BY custname HAVING COUNT(custname) > 1; Self Join: A self join can compare rows within the same table to find duplicates in the custname column, excluding matches with the same custno.
SELECT c1.custname FROM customers c1 JOIN customers c2 ON c1.custname = c2.custname AND c1.custno != c2.custno; These methods allow us to find duplicates in the custname column regardless of the custno. Options A, B, and E are not applicable methods for finding duplicates in this context.
Reference:
Oracle Documentation on Group By: Group By
Oracle Documentation on Joins: Joins

by Stanford at Oct 04, 2026, 02:12 AM

Limited Time Offer

15%

Off

Get Premium 1z0-071 Questions as Interactive Self Test Engine or PDF

Comments

Chosen Answer:
This is a voting comment (?) , you can switch to a simple comment.
Switch to a voting comment New
Nick name: Submit Cancel
A voting comment increases the vote count for the chosen answer by one.

Upvoting a comment with a selected answer will also increase the vote count towards that answer by one. So if you see a comment that you already agree with, you can upvote it instead of posting a new comment.
0
0
0
10