Which two statements are true about associative arrays and varrays? (Choose two.)
A.
Only varrays must start with the subscript 1.
B.
Only varrays can be used as column types in database tables.
C.
Both associative arrays and varrays must start with the subscript 1.
D.
Both associative arrays and varrays can be used as column types in database tables.
B and C are correct.
Sorry, A and B are correct
A and B
C and D
http://docs.oracle.com/cd/E11882_01/appdev.112/e25519/composites.htm#LNPLS443http://docs.oracle.com/cd/E11882_01/appdev.112/e25519/composites.htm#LNPLS443
http://docs.oracle.com/cd/E11882_01/appdev.112/e25519/composites.htm#LNPLS99969
http://docs.oracle.com/cd/B28359_01/appdev.111/b28371/adobjcol.htm#ADOBJ00210
Sorry
A and B are correct
A B
A,B
5 PL/SQL Collections and Records
Varrays (Variable-Size Arrays)
To access an element of a varray variable, use the syntax variable_name(index).
The lower bound of index is 1; the upper bound is the current number of elements.
The database stores a varray variable as a single object.
If a varray variable is less than 4 KB, it resides inside the table of which it is a column;
otherwise, it resides outside the table but in the same tablespace.
Associative array
Each key is a unique index, used to locate the associated value with the syntax variable_name(index).
The data type of index can be either a string type or PLS_INTEGER.
http://docs.oracle.com/cd/E11882_01/appdev.112/e25519/composites.htm#LNPLS443