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

Question : 45 of 50

Marks: +1, -0

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);

Go to Question: