Oracle
1Z0-061 · Question #302
1Z0-061 Question #302: Real Exam Question with Answer & Explanation
Sign in or unlock 1Z0-061 to reveal the answer and full explanation for question #302. The question stem and answer options stay visible for context.
Question
Examine the data in the CUSTOMERS table: You want to list all cities that have more than one customer along with the customer details. Evaluate the following query: SQL>SELECT c1.custname, c1.city FROM Customers c1 __________________ Customers c2 ON (c1.city=c2.city AND c1.custname<>c2.custname); Which two JOIN options can be used in the blank in the above query to give the correct output? (Choose two.)
Options
- AJOIN
- BNATURAL JOIN
- CLEFT OUTER JOIN
- DFULL OUTER JOIN
- ERIGHT OUTER JOIN
Unlock 1Z0-061 to see the answer
You've previewed enough free 1Z0-061 questions. Unlock 1Z0-061 for full answers, explanations, the timed quiz mode, progress tracking, and the master PDF. Question stem and options stay visible so you can still see what's on the exam.