which of the following scenarios would you recommend using PL/SQL records?

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

Explanation: