Oracle
1Z0-061 · Question #302
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…
The correct answer is A. JOIN E. RIGHT OUTER JOIN. See the full explanation below for the reasoning.
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
How the community answered
(30 responses)- A83% (25)
- B3% (1)
- C10% (3)
- D3% (1)
Community Discussion
No community discussion yet for this question.