Oracle PL[s]SQL by Example

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

1)

In a cursor FOR loop, cursor and loop handling is carried out implicitly.

  1. _____ True

  2. _____ False

2)

In a cursor FOR loop, it is necessary to declare the rowtype for the cursor.

  1. _____ True

  2. _____ False

3)

Is it necessary to open , fetch, and close a cursor in a cursor FOR loop?

  1. _____ Yes

  2. _____ No

4)

The child loop in a nested cursor is passed through how many times for each cycle of the parent?

  1. _____ Three

  2. _____ One or more

  3. _____ Two

  4. _____ It depends on the individual code.

5)

If the SELECT statement of the cursor makes use of a variable, when should the variable be declared?

  1. _____ It is a bind variable and therefore does not need to be declared.

  2. _____ In the declarative section.

  3. _____ Before the cursor that is using it.

  4. _____ It will be self-declared upon initialization.

Answers appear in Appendix A, Section 9.2 .

Related

Категории