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. Restriction on DELETE If collection is a varray, you cannot specify indexes with DELETE.

Advanced PL/SQL Features

Question

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

(54 responses)

A
72% (39)
B
6% (3)
C
4% (2)
D
19% (10)

Explanation

Restriction on DELETE If collection is a varray, you cannot specify indexes with DELETE.

Topics

#VARRAY#DELETE method restriction#collection methods#nested table

Community Discussion

No community discussion yet for this question.

Full 1Z0-146 Practice