Oracle Database 12c SQL 1z0-071 Question # 45 Topic 5 Discussion

Oracle Database 12c SQL 1z0-071 Question # 45 Topic 5 Discussion

1z0-071 Exam Topic 5 Question 45 Discussion:
Question #: 45
Topic #: 5

Examine the description of the CUSTONERS table:

1z0-071 Question 45

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.

PULL OUTER JOIN with self join


C.

subquery


D.

RIGHT OUTER JOIN with self join


E.

self Join


Get Premium 1z0-071 Questions

Contribute your Thoughts:


Chosen Answer:
This is a voting comment (?). It is better to Upvote an existing comment if you don't have anything to add.