nerdexam
Oracle

1Z0-144 · Question #80

Examine the following PL/SQL code; The execution of the code produces errors. Identify the error in the code.

The correct answer is D. The EMP_NAME and EMP_JOB variables cannot be used in the for clause of the cursor FOR. See the full explanation below for the reasoning.

Question

Examine the following PL/SQL code; The execution of the code produces errors. Identify the error in the code.

Exhibit

1Z0-144 question #80 exhibit

Options

  • AThe open cursor is missing
  • BThe fetch clause is missing
  • CThe exit when condition is missing
  • DThe EMP_NAME and EMP_JOB variables cannot be used in the for clause of the cursor FOR

How the community answered

(34 responses)
  • A
    15% (5)
  • B
    9% (3)
  • C
    6% (2)
  • D
    71% (24)

Community Discussion

No community discussion yet for this question.

Full 1Z0-144 Practice