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
|
Download Printable PDF. VALID exam to help you PASS. |
 |
Also think correct answer is A:
https://docs.oracle.com/cd/B19306_01/appdev.102/b14261/collections.htm#i20716
“The %ROWTYPE attribute lets you declare a PL/SQL record that represents a row in a database table, without listing all the columns.”