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?

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



Leave a Reply 10

Your email address will not be published. Required fields are marked *


Uladzimir

Uladzimir

A is correct

B-varray
C-nested table
D-associative array

Steve

Steve

Why does everyone disagree with TestKing’s answer of C,D (click “Show Answer” button)? Is TestKing’s answer wrong?

julio

julio

Yes, It is.

talisman

talisman

IMPORTANT.
some of TestKing’s and same dumbs answers were made BY DBMS_RANDOM PACKAGE 😀
So try to find answer urself and test all the code they show.

Alisa

Alisa

A PL/SQL record is a data structure that can hold data items of different kinds. Records consist of different fields, similar to a row of a database table.