Multiple choice technology programming languages

To increase size of a Table Type Collection/Varrays, use ...

  1. EXISTS(n)

  2. EXTEND(n)

  3. LIMIT(n)

  4. SIZE(n)
Reveal answer Fill a bubble to check yourself
B Correct answer
Explanation

In Oracle PL/SQL, the EXTEND(n) method adds n elements to the end of a collection (varray or nested table). EXISTS(n) checks if an element exists at position n, LIMIT returns the maximum size of varrays, and SIZE returns the current number of elements. Only EXTEND actually increases collection size.

Keep practicing — related questions