Oracle PL[s]SQL by Example

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

1)

SQL statements combined into PL/SQL blocks cause an increase in the network traffic.

  1. _____ True

  2. _____ False

2)

Which of the following sections is mandatory for a PL/SQL block?

  1. _____ Exception-handling section

  2. _____ Executable section

  3. _____ Declaration section

3)

The exception-handling section in a PL/SQL block is used to

  1. _____ handle compilation errors.

  2. _____ handle runtime errors.

  3. _____ handle both compilation and runtime errors.

4)

A PL/SQL compiler can detect

  1. _____ syntax errors.

  2. _____ runtime errors.

  3. _____ both compilation and runtime errors.

5)

P-code is stored in the database for

  1. _____ anonymous PL/SQL blocks.

  2. _____ named PL/SQL blocks.

Answers appear in Appendix A, Section 2.1 .

Related

Категории