View the Exhibit and examine DEPARTMENTS and the LOCATIONS tables. Evaluate the
following SOL statement: SELECT location_id, city FROM locations I WHERE NOT EXISTS
(SELECT location_id FROM departments WHERE location_id <> I. location_id); This
statement was written to display LOCATIONJD and CITY where there are no departments
located. Which statement is true regarding the execution and output of the command?
A.
The statement would not execute because the = comparison operator is missing in the
WHERE clause of the outer query.
B.
The statement would execute but it will return zero rows because the WHERE clause in
the inner query should have the = operator instead of <>.
C.
The statement would execute and would return the desired results.
D.
The statement would not execute because the WHERE clause in the outer query is
missing the column name for comparison with the inner query result.