Exit 1Z0-144 Oracle Database 11g: Program with PL/SQL
Question 4 of 5
0% complete
Q4 Single choice

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