Oracle Exam 1Z0-071 Topic 5 Question 75 Discussion

Actual exam question for Oracle's 1Z0-071 exam

Question #: 75
Topic #: 5

Examine the description of the CUSTONERS 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?

ALEFT OUTER JOIN with self join

BPULL OUTER JOIN with self join

Csubquery

DRIGHT OUTER JOIN with self join

Eself Join

Show Suggested Answer

Suggested Answer: D, E

by Tammara at May 26, 2023, 06:07 AM

Limited Time Offer

25%

Off

Contribute your Thoughts:

Submit Cancel

10 days ago

Wait, what's a PULL OUTER JOIN? Is that like a superhero move or something? I'm sticking with the good old self join.

upvoted 0 times

...

22 days ago

I'm not sure about the other options, but a self join seems like the most logical choice here.

upvoted 0 times

...

22 days ago

Hmm, LEFT OUTER JOIN with self join seems like the way to go. I can already visualize the query in my head!

upvoted 0 times

...

25 days ago

I agree with Emilio. A self join would be a good method to find duplicate names.

upvoted 0 times

...

27 days ago

I think we can use a self join to get the required result.

upvoted 0 times

...