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 12 Procedures

Lab 12.2 ▪ Self-Review Answers

A1:
Questions Answers Comments
1) C 
A2:
Questions Answers Comments
2) A, C, D, E There is no foot section in stored code. The specification can be called the header, but the body is never called footer.
A3:
Questions Answers Comments
3) B An OUT parameter is not a required component of a procedure.
A4:
Questions Answers Comments
4) A, B, D C is a valid definition for the declarative section; all header definitions refer to IN, OUT, or IN/OUT parameters.
A5:
Questions Answers Comments
5) B The USER_SOURCE view shows the text for code in valid and invalid objects.

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