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

Benjamin Rosenzweig

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

Lab 11.2 Self-Review Questions

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

1)

A pragma is

  • _____ a special procedure provided by Oracle.

  • _____ a special instruction to the compiler.

  • 2)

    A pragma is processed during

  • _____ runtime.

  • _____ compile time.

  • 3)

    The EXCEPTION_INIT pragma associates a

  • _____ built-in exception with a user-defined error number.

  • _____ user-defined exception with a user-defined error number.

  • _____ user-defined exception with an Oracle error number.

  • 4)

    The EXCEPTION_INIT pragma needs which of the following parameters?

  • _____ error_number only

  • _____ error_name only

  • _____ error_name and error_number

  • 5)

    Which of the following is a valid error_number parameter?

  • _____ ORA-02292

  • _____ 2292

  • _____ -2292

  • Answers appear in Appendix A,

    Section 11.2 .