Lab 20.2 Self-Review Questions

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

1)	The OPEN-FOR, FETCH, and CLOSE statements are used only for single-row queries. _____ TRUE _____ FALSE
2)	The OPEN-FOR statement has an optional USING clause. _____ TRUE _____ FALSE
3)	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
4)	After the CLOSE statement executes, _____ the result set becomes undefined. _____ the result set is still available for further processing.
5)	It is illegal to fetch data returned by a cursor into a user -defined record variable. _____ TRUE _____ FALSE

Answers appear in Appendix A, Section 20.2 .