nerdexam
Oracle

1Z0-146 · Question #136

View the Exhibit and examine the code in the PL/SQL block. The PL/SQL block generates an error on execution. What is the reason?

The correct answer is A. The DELETE(n) method cannot be used with varrays. Varrays are dense, so you cannot delete their individual elements.

Advanced PL/SQL Features

Question

View the Exhibit and examine the code in the PL/SQL block. The PL/SQL block generates an error on execution. What is the reason?

Exhibit

1Z0-146 question #136 exhibit

Options

  • AThe DELETE(n) method cannot be used with varrays.
  • BThe DELETE(n) method cannot be used with nested tables.
  • CThe NEXT method cannot be used with an associative array with VARCHAR2 key values.
  • DThe NEXT method cannot be used with a nested table from which an element has been deleted.

How the community answered

(55 responses)
  • A
    84% (46)
  • B
    2% (1)
  • C
    5% (3)
  • D
    9% (5)

Explanation

Varrays are dense, so you cannot delete their individual elements.

Topics

#collection methods#DELETE method#varray#nested table

Community Discussion

No community discussion yet for this question.

Full 1Z0-146 Practice