In which of the following scenarios would you recommend using PL/SQL records?
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 in memory each time a subprogram is invoked
I think answer is C and D
Correct.
http://docs.oracle.com/cd/B19306_01/appdev.102/b14261/collections.htm#i20716
I think A is correct.
your answer seems to be in contradiction to this:
http://www.aiotestking.com/oracle/2012/01/which-of-the-following-scenarios-would-you-recommend-using-associative-arrays/
a:records
d: ?? (varrays ??)
c:nested tables
d: associative arrays
A is correct.
http://class10e.com/oracle/exams/1z0-144/?do=test
La respuesta correcta es la A).
A