Chapter 9 Introduction to Cursors

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 9.1 Self-Review Answers

A1:

Questions

Answers

Comments

1)

B

 

A2:

Questions

Answers

Comments

2)

None

Cursor attributes are used for getting information about cursors. They cannot be used to control or close cursors.

A3:

Questions

Answers

Comments

3)

1-B Declare, 2-E Open, 3-A Fetch, 4-C Close

 

A4:

Questions

Answers

Comments

4)

D

Cursor attributes can be use with both implicit and explicit cursors.

A5:

Questions

Answers

Comments

5)

D

 

Lab 9.2 Self-Review Answers

A1:

Questions

Answers

Comments

1)

A

 

A2:

Questions

Answers

Comments

2)

B

 

A3:

Questions

Answers

Comments

3)

B

 

A4:

Questions

Answers

Comments

4)

B

A child cursor in a nested cursor loop will open, loop, and then close for each iteration of the parent loop.

A5:

Questions

Answers

Comments

5)

C

 

Lab 9.3 Self-Review Answers

Questions

Answers

Comments

1)

A

 

2)

A, B, E

 

3)

C

 

4)

C

 

5)

A

A WHERE CURRENT clause in a FOR UPDATE cursor allows you to update a row without having to match the row in the WHERE clause.


    Team-Fly    
    Top
     



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

    Similar book on Amazon

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