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 each department.
Which SOL statement would you execute to accomplish the task?
A. UPDATE deptdSET city = ANY (SELECT city FROM locations I);
B. UPDATE deptdSET city = (SELECT cityFROM locations I)WHERE d.location_id = l.location_id;
C. UPDATE dept dSET city = (SELECT cityFROM locations IWHERE d.location_id = l.location_id);
D. UPDATE dept dSET city = ALL (SELECT cityFROM locations IWHERE d.location_id =location_id);