Which SET operator should be used in the blank space in the following SQL statement to display the cities

Prev Question
Next Question

View the Exhibit and examine the structure of the LOCATIONS and DEPARTMENTS tables.

Exam 1Z0-047 - Which SET operator should be used in the blank space in the following SQL statement to display the cities

Which SET operator should be used in the blank space in the following SQL statement to display the cities that have departments located in them?
SELECT location_id, city
FROM locations
____
SELECT location_id, city
FROM locations JOIN departments
USING(location_id);

A.
UNION

B.
MINUS

C.
INTERSECT

D.
UNION ALL

Prev Question
Next Question

Leave a Reply

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