Multiple choice technology databases

which of the following is TRUE about collections.

  1. Only nested tables need initilization.

  2. Index-by tables is a persistent collection

  3. nested tables are known as associative arrays.

  4. VARRAYs hold fixed number of elements
Reveal answer Fill a bubble to check yourself
D Correct answer
Explanation

In PL/SQL, VARRAYs (variable-size arrays) are defined with a maximum limit and hold a fixed maximum number of elements. Associative arrays are known as index-by tables, and nested tables do not persist in database columns without a storage table.

Keep practicing — related questions