In order to test your progress, you should be able to answer the following questions.
Implicit cursors are the only way to fetch and manage data from the database.
_____ True
_____ False
What are cursor attributes used for?
_____ Controlling cursors
_____ Populating cursors
_____ Ordering pizza
_____ Closing cursors
Number the following steps in processing a cursor.
_____ Fetch
_____ Declare
_____ Close
_____ Open
_____ Dance
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.
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 .