nerdexam
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

1Z0-144 question #101 exhibit

Options

  • ABind
  • BParse
  • CFetch
  • DExecute

How the community answered

(34 responses)
  • A
    29% (10)
  • B
    71% (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.

Full 1Z0-144 Practice