Oracle Database SQL 12c 1z0-071 Exam Practice Test 2

Question : 27 of 50

Marks: +1, -0

Examine the structure of the CUSTOMERS table:

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? (Choose two.)Which two methods can you use to get the required result? (Choose two.)

Subquery
Self-join
Full outer-join with self-join
Left outer-join with self-join
Right outer-join with self-join

Validate

Go to Question:

Prev Question

Next Question