Exam 1z0-149 All QuestionsBrowse all questions from this exam
Question 11

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

    Correct Answer: A, C

    A variable of RECORD type can contain fields of another RECORD type or any collection type. All collections and RECORD types can be defined in PL/SQL blocks, packages, or at the schema level. Unlike nested tables and associative arrays, varrays can contain elements of RECORD type, and collections can be both sparse and dense. Additionally, not all collections and RECORD types can be stored in table columns, and they do not always have default values of null except in specific circumstances.

Discussion
abdullah_barhamOptions: AF

I tried Each the answer will be A + F

TheOracleWasTakenOptions: AF

A is fo sure correct and the other least wrong answer seems like F

jm9999Options: AF

Varrays can also have elements of record type.

thranduylOptions: AF

A, IS CORRECT

Goto10Options: AC

B is wrong since RECORD can have elements of another RECORD type