Prentice Hall Oracle Plsql By Example 3Rd Edition [Electronic resources]

Benjamin Rosenzweig

نسخه متنی -صفحه : 289/ 128
نمايش فراداده

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

  • _____ declared.

  • _____ declared and raised.

  • 2)

    How does any user-defined exception get raised?

  • _____ Implicitly

  • _____ Explicitly

  • 3)

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

  • _____ True

  • _____ False

  • 4)

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

  • _____ True

  • _____ False

  • 5)

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

  • _____ IF-THEN and RAISE statements

  • _____ IF-THEN statement only

  • _____ RAISE statement only

  • Answers appear in Appendix A,

    Section 10.2 .