nerdexam
Oracle

1Z0-144 · Question #13

View the exhibit and examine the structure of the EMPLOYEES table The salary of EMPLOYEE_ID 195 is 2800. You execute the following code What is the outcome?

The correct answer is C. It executes successfully and displays the resultant values in the following sequence-1000, 2800. See the full explanation below for the reasoning.

Question

View the exhibit and examine the structure of the EMPLOYEES table The salary of EMPLOYEE_ID 195 is 2800. You execute the following code What is the outcome?

Exhibits

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

Options

  • AIt gives an error because only the innermost block is labeled.
  • BIt gives an error because the same variable name cannot be used across all the nested blocks.
  • CIt executes successfully and displays the resultant values in the following sequence-1000, 2800
  • DIt executes successfully and displays the resultant values in the following sequence:

How the community answered

(68 responses)
  • A
    13% (9)
  • B
    4% (3)
  • C
    76% (52)
  • D
    6% (4)

Community Discussion

No community discussion yet for this question.

Full 1Z0-144 Practice