Prentice Hall Oracle Plsql By Example 3Rd Edition [Electronic resources]

1)

C

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.

3)

B

An OUT parameter is not a required component of a procedure.

4)

A, B, D

C is a valid definition for the declarative section; all header definitions refer to IN, OUT, or IN/OUT parameters.

5)

B

The USER_SOURCE view shows the text for code in valid and invalid objects.