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.)
A.
JOIN
B.
NATURAL JOIN
C.
LEFT OUTER JOIN
D.
FULL OUTER JOIN
E.
RIGHT OUTER JOIN
“Roni
January 23, 2016 at 11:09 pm
In my opinion The CORRECT answear is only A(Join), but the most acceptable answear is A(Join) and E(Right Join), because RIGHT OUTER JOIN will return 4 rows(2 of them with null values), hiding the custname(SMITH and GREEN) of the table C2 as it is not on the SELECT list.
CUSTNAME CITY
——————– ——————–
KING SEATTLE
KOCHAR SEATTLE
(null) (null)
(null) (null)
If LEFT JOIN was used it would be completely wrong, because it would return the following rows
CUSTNAME CITY
——————– ——————–
KING SEATTLE
KOCHAR SEATTLE
SMITH NEW YORK
GREEN BOSTON”
https://equizzing.com/oracle/which-two-join-options-can-be-used-in-the-blank-in-the-above-query-to-give-the-correct-output/
C and A