Oracle PL[s]SQL by Example

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

1)

A compiler can detect a runtime error.

  1. _____ True

  2. _____ False

2)

Without an exception-handling section, a PL/SQL block cannot be compiled.

  1. _____ True

  2. _____ False

3)

An exception is raised when which of the following occurs?

  1. _____ A compilation error is encountered .

  2. _____ A runtime error is encountered.

4)

An exception-handling section of a PL/SQL block is placed

  1. _____ after the reserved word END.

  2. _____ before the reserved word END.

  3. _____ before the reserved word BEGIN.

5)

The exception ZERO_DIVIDE is raised when number 1 is divided by number 2 and

  1. _____ number 1 is equal to 0.

  2. _____ number 2 is equal to 0.

  3. _____ both numbers are equal to 0.

Answers appear in Appendix A, Section 7.1 .

Related

Категории