Oracle PL[s]SQL by Example

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.

  1. _____ TRUE

  2. _____ FALSE

2)

The OPEN-FOR statement has an optional USING clause.

  1. _____ TRUE

  2. _____ FALSE

3)

For a multi-column result set, the FETCH statement

  1. _____ always causes an error.

  2. _____ returns a single column into one variable at a time.

  3. _____ returns a single row into a list of variables

4)

After the CLOSE statement executes,

  1. _____ the result set becomes undefined.

  2. _____ 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.

  1. _____ TRUE

  2. _____ FALSE

Answers appear in Appendix A, Section 20.2 .

Related

Категории