In which of the following scenarios would you recommend using associative arrays?
A. When you want to retrieve an entire row from a table and perform calculations
B. When you know the number of elements in advance and the elements are usually accessed sequentially
C. When you want to create a separate lookup table with multiple entries for each row of the main table, and access it through join queries
D. When you want to create a relatively small lookup table, where the collection can be constructed on memory each time a subprogram is invoked.
Also think that correct answer is D.
Adding reference:
https://docs.oracle.com/cd/E11882_01/appdev.112/e25519/composites.htm#LNPLS99930
“An associative array is appropriate for:
A relatively small lookup table, which can be constructed in memory each time you invoke the subprogram or initialize the package that declares it”