nerdexam
Oracle

1Z0-144 · Question #102

View the Exhibit and examine the structure of the SALGRADE table. Examine the following code: What is the outcome?

The correct answer is C. It gives an error because the usage of the host variables is invalid. See the full explanation below for the reasoning.

Question

View the Exhibit and examine the structure of the SALGRADE table. Examine the following code:

What is the outcome?

Exhibits

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

Options

  • AIt is created successfully.
  • BIt gives an error because the return clause condition is invalid.
  • CIt gives an error because the usage of the host variables is invalid.
  • DIt gives an error because the data type of the return clause is invalid.

How the community answered

(34 responses)
  • A
    3% (1)
  • B
    12% (4)
  • C
    79% (27)
  • D
    6% (2)

Community Discussion

No community discussion yet for this question.

Full 1Z0-144 Practice