Oracle Database SQL 12c 1z0-071 Exam Practice Test 1

Question : 45 of 50

Marks: +1, -0

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

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 eachdepartment.
Which SQL statement would you execute to accomplish the task?

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

Validate

Go to Question:

Prev Question

Next Question