nerdexam
Oracle

1Z0-144 · Question #16

View Exhibit1 and examine the structure of the employees table. View Exhibit2 and examine the code. What is the outcome when the code is executed?

The correct answer is A. Both blocks compile and execute successfully when called. See the full explanation below for the reasoning.

Question

View Exhibit1 and examine the structure of the employees table. View Exhibit2 and examine the code. What is the outcome when the code is executed?

Exhibits

1Z0-144 question #16 exhibit 1
1Z0-144 question #16 exhibit 2

Options

  • ABoth blocks compile and execute successfully when called.
  • BBoth blocks compile successfully but the CALC_SAL procedure gives an error on execution.
  • CThe CALC_SAL procedure gives an error on compilation because the amt variable should be
  • DThe CALC_SAL procedure gives an error on compilation because the RAISE_SALARY

How the community answered

(14 responses)
  • A
    71% (10)
  • B
    7% (1)
  • C
    14% (2)
  • D
    7% (1)

Community Discussion

No community discussion yet for this question.

Full 1Z0-144 Practice