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