nerdexam
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)
  • A
    83% (25)
  • B
    3% (1)
  • C
    10% (3)
  • D
    3% (1)

Community Discussion

No community discussion yet for this question.

Full 1Z0-061 Practice