O'Reilly logo

Oracle® PL/SQL® Interactive Workbook, Second Edition by Elena Silvestrova, Benjamin Rosenzweig

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

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 ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required