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:

Which two JOIN options can be used in the blank in the above query to give the correct output? (Choose two.)

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:

Which two JOIN options can be used in the blank in the above query to give the correct output? (Choose two.)

Accepted Answer

B. JOIN D. RIGHT OUTER JOIN

Answer

A. LEFT OUTER JOIN

Answer

C. NATURAL JOIN

Answer

E. FULL OUTER JOIN

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: Which two JOIN options can be…