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

Estrella

1 months ago

This question is making my brain hurt. I'm just going to go with B and E and hope the exam grader takes pity on me. At least I won't have to worry about null values in my VARRAYS - they'll all be nice and dense, just like my study habits.

upvoted 0 times

...

Kanisha

1 months ago

Hmm, I'm not too sure about this one. I think D is true - collections and RECORD types are always dense, right? Wait, is that even a real thing? I'm just going to guess A and C and hope for the best.

upvoted 0 times

...

Lucia

2 months 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

Clarinda

6 days ago

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

upvoted 0 times

...

Rosita

6 days ago

And don't forget that VARRAYS, nested tables, and %ROWTYPE fields have a default value of null.

upvoted 0 times

...

Lai

7 days ago

Yes, that's right. All collections and RECORD types can be defined in PL/SQL blocks, packages, or at the schema level.

upvoted 0 times

...

Sena

12 days ago

I think A, C, and F are correct. RECORD types can have fields of any collection type.

upvoted 0 times

...

Curtis

12 days ago

Yes, you're right. RECORD types can have fields of any collection type.

upvoted 0 times

...

Catalina

28 days ago

I think A, C, and F are the correct options.

upvoted 0 times

...

Lindsey

2 months 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

...