What happens during the execute phase with dynamic SQL for INSERT, UPDATE, and DELETE operations?
A.
The rows are selected and ordered.
B.
The validity of the SQL statement is established.
C.
An area of memory is established to process the SQL statement.
D.
The SQL statement is run and the number of rows processed is returned.
E.
The area of memory established to process the SQL statement is released.
Explanation:
All SQL statements have to go through various stages. Some stages may be skipped.
1. Parse
Every SQL statement must be parsed. Parsing the statement includes checking the statement’s syntax and validating the statement, ensuring that all references to objects are correct, and ensuring that the relevant privileges to those objects exist.
2. Bind
After parsing, the Oracle server knows the meaning of the Oracle statement but still may not have enough information to execute the statement. The Oracle server may need values for any bind variable in the statement. The process of obtaining these values is called binding variables.
3. Execute
At this point, the Oracle server has all necessary information and resources, and the statement is executed.
4. Fetch
In the fetch stage, rows are selected and ordered (if requested by the query), and each successive fetch retrieves another row of the result, until the last row has been fetched. You can fetch queries, but not the DML statements.
D