Chapter 9 Introduction to Cursors


Chapter 9 Introduction to Cursors

Lab 9.1 Self-Review Answers

A5:

Questions

Answers

Comments

1)

B

 

2)

None

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

3)

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

 

4)

D

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

5)

D

 

Lab 9.2 Self-Review Answers

A5:

Questions

Answers

Comments

1)

A

 

2)

B

 

3)

B

 

4)

B

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

5)

C

 



Oracle PL[s]SQL by Example
Oracle PL[s]SQL by Example
ISBN: 3642256902
EAN: N/A
Year: 2003
Pages: 289

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