A) TRUE I created a variable of RECORD type which contains another RECORD type and all collection types. The code compiled and ran fine.
B) Not true since A is true
C) Not true. RECORD types cannot be defined at the schema level.
D) Nested tables and associative arrays can be sparse.
E) Associative arrays (index-by tables) cannot be stored in database columns.
F) TRUE VARRAYS, nested tables, and fields of a %ROWTYPE variable are initialized to NULL by default unless explicitly initialized. I tested this in SQL Developer and verified that it is true.
B is wrong since RECORD can have elements of another RECORD type
upvoted 1 times
...
Log in to ExamTopics
Sign in:
Community vote distribution
A (35%)
C (25%)
B (20%)
Other
Most Voted
A voting comment increases the vote count for the chosen answer by one.
Upvoting a comment with a selected answer will also increase the vote count towards that answer by one.
So if you see a comment that you already agree with, you can upvote it instead of posting a new comment.
abdullah_barham
Highly Voted 1 year, 10 months agoThe_Potentate
Most Recent 4 months, 3 weeks agoahmed0_10101
5 months, 2 weeks agothranduyl
1 year, 1 month agoTheOracleWasTaken
1 year, 4 months agojm9999
1 year, 6 months agoGoto10
1 year, 10 months ago