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.

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.

Start your free trial