Oracle
1Z0-071 · Question #355
Examine this SQL statement: Which two are true?
The correct answer is A. All existing rows in the ORDERS table are updated C. The subquery is executed before the UPDATE statement is executed. See the full explanation below for the reasoning.
Question
Examine this SQL statement:
Which two are true?
Exhibit
Options
- AAll existing rows in the ORDERS table are updated
- BThe subquery is executed for every updated row in the ORDERS table
- CThe subquery is executed before the UPDATE statement is executed
- DThe subquery is not a correlated subquery
- EThe UPDATE statement executes successfully even if the subquery selects multiple rows
How the community answered
(21 responses)- A71% (15)
- B5% (1)
- D10% (2)
- E14% (3)
Community Discussion
No community discussion yet for this question.