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

  1. _____ a special procedure provided by Oracle.

  2. _____ a special instruction to the compiler.

2)

A pragma is processed during

  1. _____ runtime.

  2. _____ compile time.

3)

The EXCEPTION_INIT pragma associates a

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

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

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

4)

The EXCEPTION_INIT pragma needs which of the following parameters?

  1. _____ error_number only

  2. _____ error_name only

  3. _____ error_name and error_number

5)

Which of the following is a valid error_number parameter?

  1. _____ ORA-02292

  2. _____ 2292

  3. _____ -2292


Answers appear in Appendix A, Section 11.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