Oracle PL[s]SQL by Example

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

1)

The RAISE_APPLICATION_ERROR works with which of the following?

  1. _____ Named user -defined exceptions only

  2. _____ Unnamed user-defined exceptions only

  3. _____ Built-in and unnamed user-defined exceptions

2)

The RAISE_APPLICATION_ERROR procedure requires which of the following parameters?

  1. _____ error_number, error_text, keep_error

  2. _____ error_text, keep_error

  3. _____ error_number, error_text

3)

The error number used in the RAISE_APPLICATION_ERROR must be which of the following?

  1. _____ A number between -20,000 and -20,999

  2. _____ A number between 20,000 and 20,999

4)

The RAISE_APLICATION_ERROR halts the execution of the program.

  1. _____ True

  2. _____ False

5)

When the parameter keep_error is set to TRUE, which of the following occurs?

  1. _____ An error message is displayed on the screen.

  2. _____ An error number is displayed on the screen.

  3. _____ A new error message is added to the list of raised error messages.

Answers appear in Appendix A, Section 11.1 .

Related

Категории