Oracle PL[s]SQL by Example

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 .

Категории