Oracle PL[s]SQL by Example

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 .

Related

Категории