Which two JOIN options can be used in the blank in the …

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.)

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



Leave a Reply 1

Your email address will not be published. Required fields are marked *