Lab 8.4 Self-Review Questions


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

1)

What types of PL/SQL loop can be nested one inside another?

  1. _____ A simple loop can only be nested inside WHILE loop.

  2. _____ A WHILE loop can only be nested inside simple loop.

  3. _____ Any loop can be nested inside another loop.

2)

When nested loops are used, you must use loop labels.

  1. _____ True

  2. _____ False

3)

When a loop label is defined, you must use it with an END LOOP statement.

  1. _____ True

  2. _____ False

4)

When nested loops are used, it is recommended that you use the same name for the loop counters.

  1. _____ True

  2. _____ False

5)

If the loop label is defined, you must use it when the loop counter is referenced.

  1. _____ True

  2. _____ False


Answers appear in Appendix A, Section 8.4 .



Oracle PL[s]SQL by Example
Oracle PL[s]SQL by Example
ISBN: 3642256902
EAN: N/A
Year: 2003
Pages: 289

flylib.com © 2008-2017.
If you may any questions please contact us: flylib@qtcs.net