Multiple choice technology databases

Which two statements are true about associative arrays and varrays? (Choose two.)

  1. Only varrays must start with the subscript 1.

  2. Only varrays can be used as column types in database tables.

  3. Both associative arrays and varrays must start with the subscript 1.

  4. Both associative arrays and varrays can be used as column types in database tables.
Reveal answer Fill a bubble to check yourself
A,B Correct answer
Explanation

Varrays must start with subscript 1 and can be stored as table columns. Associative arrays have flexible indexing (including negative or string keys) and cannot be column types: they exist only in PL/SQL memory.

Keep practicing — related questions