Which SQL statement would you execute to accomplish the task?

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

You want to update the CITY column of theDEPT 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. Option A
B. Option B
C. Option C
D. Option D

Download Printable PDF. VALID exam to help you PASS.

Leave a Reply

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


The reCAPTCHA verification period has expired. Please reload the page.