Chapter 12 Procedures

Team-Fly    

Oracle® PL/SQL® Interactive Workbook, Second Edition
By Benjamin Rosenzweig, Elena Silvestrova
Table of Contents
Appendix A.  Answers to Self-Review Questions


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.


    Team-Fly    
    Top
     



    Oracle PL. SQL Interactive Workbook
    Oracle PL/SQL Interactive Workbook (2nd Edition)
    ISBN: 0130473200
    EAN: 2147483647
    Year: 2002
    Pages: 146

    flylib.com © 2008-2017.
    If you may any questions please contact us: flylib@qtcs.net