Oracle
1Z0-147 · Question #9
What happens during the execute phase with dynamic SQL for INSERT, UPDATE, and DELETE operations?
The correct answer is D. The SQL statement is run and the number of rows processed is returned. See the full explanation below for the reasoning.
Question
What happens during the execute phase with dynamic SQL for INSERT, UPDATE, and DELETE operations?
Options
- AThe rows are selected and ordered.
- BThe validity of the SQL statement is established.
- CAn area of memory is established to process the SQL statement.
- DThe SQL statement is run and the number of rows processed is returned.
- EThe area of memory established to process the SQL statement is released.
How the community answered
(29 responses)- A14% (4)
- B3% (1)
- C7% (2)
- D72% (21)
- E3% (1)
Community Discussion
No community discussion yet for this question.