nerdexam
Oracle

1Z0-144 · Question #65

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

The correct answer is A. It executes successfully. 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 would be the outcome when the code is executed?

Exhibits

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

Options

  • AIt executes successfully.
  • BIt gives an error because the SAL variable is not visible in the increase function.
  • CIt gives an error because the increase function cannot be called from the RAISE_SALARY
  • DIt gives an error because the increase function and the RAISE_SALARY procedure should be

How the community answered

(57 responses)
  • A
    81% (46)
  • B
    12% (7)
  • C
    5% (3)
  • D
    2% (1)

Community Discussion

No community discussion yet for this question.

Full 1Z0-144 Practice