Lab 10.2 Self-Review Questions


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

1)

In order to use a user -defined exception, it must be

  1. _____ declared.

  2. _____ declared and raised.

2)

How does any user-defined exception get raised?

  1. _____ Implicitly

  2. _____ Explicitly

3)

If a user-defined exception has been declared in the inner block, it can be raised in the outer block.

  1. _____ True

  2. _____ False

4)

When a user-defined exception is raised and executed, control is passed back to the PL/SQL block.

  1. _____ True

  2. _____ False

5)

A user-defined exception is raised with the help of which of the following?

  1. _____ IF-THEN and RAISE statements

  2. _____ IF-THEN statement only

  3. _____ RAISE statement only


Answers appear in Appendix A, Section 10.2 .



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