Oracle
1Z0-144 · Question #101
View the Exhibit and examine the structure of the EMP table. Which stages are performed when the above block is executed? (Choose all that apply)
The correct answer is B. Parse C. Fetch D. Execute. There are no bind variables. So it will not go into bind phase.
Using Cursors
Question
View the Exhibit and examine the structure of the EMP table. Which stages are performed when the above block is executed? (Choose all that apply)
Exhibit
Options
- ABind
- BParse
- CFetch
- DExecute
How the community answered
(34 responses)- A29% (10)
- B71% (24)
Explanation
There are no bind variables. So it will not go into bind phase.
Topics
#SQL execution phases#parse bind execute fetch#cursor processing#implicit cursor
Community Discussion
No community discussion yet for this question.
