Oracle Exam 1Z0-149 Topic 9 Question 41 Discussion

Actual exam question for Oracle's 1Z0-149 exam

Question #: 41
Topic #: 9

[All 1Z0-149 Questions]

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

AA variable of RECORD type can contain fields of another RECORD type or any collection type.

BOnly associative arrays and nested tables can have elements of RECORD type.

CAll collections and RECORD types can be defined in PL/SQL blocks, packages, or at the schema level.

DCollections and RECORD types are always dense.

EAll collections and RECORD types can be stored in table columns.

FVARRAYS, nested tables and each field in %ROWTYPE type variables have a default value of null.

Show Suggested Answer

Suggested Answer: A, D

https://docs.oracle.com/database/122/LNPLS/ACCESSIBLE-BY-clause.htm

by Arminda at Oct 23, 2024, 08:46 PM

Limited Time Offer

25%

Off

Get Premium 1Z0-149 Questions as Interactive Web-Based Practice Test or PDF

Contribute your Thoughts:

Submit Cancel

Lucia

4 days ago

This question is a piece of cake! A, C, and F are all true. RECORD types can have fields of any collection type, and all collections and RECORD types can be defined anywhere in PL/SQL. Also, VARRAYS, nested tables, and %ROWTYPE fields have a default value of null.

upvoted 0 times

...

Lindsey

9 days ago

B and E are definitely true. RECORD types can only be used with associative arrays and nested tables, and all collections and RECORD types can be stored in table columns.

upvoted 0 times

...