Prev Question
Next Question

View the Exhibit and examine the descriptions of the DEPT and LOCATIONS tables.

5a10496c8ca87 - Which SQL statement would you execute to accomplish the task?

You want to update the CITY column of the DEPT table for all the rows with the corresponding value in the CITY column of the LOCATIONS table for each department.

Which SQL statement would you execute to accomplish the task?

A.
UPDATE dept d
SET city = ANY (SELECT city
FROM locations l);

B.
UPDATE dept d
SET city = (SELECT city
FROM locations l)
WHERE d.location_id = l.location_id;

C.
UPDATE dept d
SET city = (SELECT city
FROM locations l
WHERE d.location_id = l.location_id);

D.
UPDATE dept d
SET city = ALL (SELECT city
FROM locations l
WHERE d.location_id = l.location_id);

Prev Question
Next Question

Leave a Reply

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