Multiple choice technology databases

What happens during the execute phase with dynamic SQL for INSERT, UPDATE, and DELETE operations?

  1. The rows are selected and ordered.

  2. The validity of the SQL statement is established.

  3. An area of memory is established to process the SQL statement.

  4. The SQL statement is run and the number of rows processed is returned.
Reveal answer Fill a bubble to check yourself
D Correct answer
Explanation

In dynamic SQL processing, the execute phase runs the actual SQL statement and returns the count of affected rows. For INSERT/UPDATE/DELETE, this is when data modification happens and row counts are returned. Selecting/ordering rows (A) happens for queries. Validity checking (B) is parse phase. Memory allocation (C) is define/prepare phase.

Keep practicing — related questions