Oracle
1Z0-047 · Question #263
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…
The correct answer is C. UPDATE dept d. See the full explanation below for the reasoning.
Question
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?
Exhibit
Options
- AUPDATE dept d
- BUPDATE dept d
- CUPDATE dept d
- DUPDATE dept d
How the community answered
(33 responses)- A9% (3)
- B3% (1)
- C82% (27)
- D6% (2)
Community Discussion
No community discussion yet for this question.