Lab 9.2 Self-Review Questions

In order to test your progress, you should be able to answer the following questions.

1)	In a cursor FOR loop, cursor and loop handling is carried out implicitly. _____ True _____ False
2)	In a cursor FOR loop, it is necessary to declare the rowtype for the cursor. _____ True _____ False
3)	Is it necessary to open , fetch, and close a cursor in a cursor FOR loop? _____ Yes _____ No
4)	The child loop in a nested cursor is passed through how many times for each cycle of the parent? _____ Three _____ One or more _____ Two _____ It depends on the individual code.
5)	If the SELECT statement of the cursor makes use of a variable, when should the variable be declared? _____ It is a bind variable and therefore does not need to be declared. _____ In the declarative section. _____ Before the cursor that is using it. _____ It will be self-declared upon initialization.

Answers appear in Appendix A, Section 9.2 .