Lab 9.1 Self-Review Questions

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

1)	Implicit cursors are the only way to fetch and manage data from the database. _____ True _____ False
2)	What are cursor attributes used for? _____ Controlling cursors _____ Populating cursors _____ Ordering pizza _____ Closing cursors
3)	Number the following steps in processing a cursor. _____ Fetch _____ Declare _____ Close _____ Open _____ Dance
4)	What is the difference between an implicit and an explicit cursor? _____ An implicit cursor is easier to manage. _____ Cursor attributes can only be used on explicit cursors. _____ It is easier to trap errors with implicit cursors. _____ Explicit cursors give the programmer greater control.
5)	What must be done to place a cursor in memory? _____ It must be fetched . _____ It must be pinned. _____ It must be memorized verbatim. _____ It must be declared.

Answers appear in Appendix A, Section 9.1 .