Chapter 18 Collections

Lab 18.1 ▪ Self-Review Answers

A1:
Questions Answers Comments
1) A 
A2:
Questions Answers Comments
2) C You will recall that a following is always used in an index-by table declaration
INDEX BY BINARY_INTEGER; 
A3:
Questions Answers Comments
3) A A nested table is automatically NULL when it is declared. As a result, it must be initialized prior to its use.
A4:
Questions Answers Comments
4) C If a PL/SQL table contains only one element, it is its first and last element. As a result, the FIRST method returns the subscript of the first element, 1, and the LAST method returns the subscript of the last element, 1.
A5:
Questions Answers Comments
5) C It is important to remember that a PL/SQL table in this case is a nested ...

Get Oracle® PL/SQL® Interactive Workbook, Second Edition now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.