nerdexam
Oracle

1Z0-146 · Question #2

View the Exhibit and examine the PL/SQL code. Which statement is true about the execution of the PL/SQL code?

The correct answer is C. The SELECT statement generates an error because the nested table has not been initialized in. See the full explanation below for the reasoning.

Question

View the Exhibit and examine the PL/SQL code. Which statement is true about the execution of the PL/SQL code?

Exhibit

1Z0-146 question #2 exhibit

Options

  • AIt executes successfully and displays 101 and 200000 values.
  • BThe ASSIGN_VAL function generates an error during compilation because nested tables cannot
  • CThe SELECT statement generates an error because the nested table has not been initialized in
  • DThe ASSIGN_VAL function generates an error during compilation because the EXTEND method

How the community answered

(35 responses)
  • A
    3% (1)
  • B
    6% (2)
  • C
    80% (28)
  • D
    11% (4)

Community Discussion

No community discussion yet for this question.

Full 1Z0-146 Practice