In order to test your progress, you should be able to answer the following questions.
The OPEN-FOR, FETCH, and CLOSE statements are used only for single-row queries.
The OPEN-FOR statement has an optional USING clause.
For a multi-column result set, the FETCH statement
_____ always causes an error.
_____ returns a single column into one variable at a time.
_____ returns a single row into a list of variables
After the CLOSE statement executes,
_____ the result set becomes undefined.
_____ the result set is still available for further processing.
It is illegal to fetch data returned by a cursor into a user -defined record variable.
Answers appear in Appendix A, Section 20.2 .