Multiple choice technology databases

Which is performance friendly

  1. VARRAY

  2. PL/SQL TABLE

  3. NESTED TABLE

  4. NONE OF THESE

Reveal answer Fill a bubble to check yourself
A Correct answer
Explanation

VARRAY (Varying Array) is the most performance-friendly collection type in Oracle because it's stored inline with the table data, has a fixed maximum size, and uses contiguous memory allocation. PL/SQL tables (associative arrays) and nested tables have more memory overhead.