Oracle Database: Advanced PL/SQL — Question 14

Which two are true about collections and RECORD types? (Choose two.)

Answer options

• A. A variable of RECORD type can contain fields of another RECORD type or any collection type.
• B. Only associative arrays and nested tables can have elements of RECORD type.
• C. All collections and RECORD types can be defined in PL/SQL blocks, packages, or at the schema level.
• D. Collections and RECORD types are always dense.
• E. All collections and RECORD types can be stored in table columns.
• F. VARRAYS, nested tables and each field in %ROWTYPE type variables have a default value of null.

Correct answer: A, F

Explanation

Option A is correct because a RECORD type can indeed hold fields from other RECORD types or any collection types. Option F is also accurate as VARRAYS, nested tables, and fields in %ROWTYPE do have a default value of null. The other options contain inaccuracies about the definitions and properties of collections and RECORD types.