Exam 5: Procedures

The term server-side refers to code that resides on the client machine.

The ____ area of a block determines what happens if an error occurs.

____ is a compiler directive.

In a(n) ____________________, you associate a value to each parameter by name in the invoke statement.

The term autonomous transaction refers to additional instructions for the PL/SQL compiler to use during program unit compilation. _________________________

The parameters in the procedure declaration of an application are called actual parameters. _________________________

The variable name ____ conforms to Oracle11g naming standards.

In a(n) positional method, you associate a value to each parameter by name in the invoke statement. _________________________

What is the difference between a function and a procedure?

Debugging is the process of identifying and removing errors from within program code. _________________________

____ can accept and return none, one, or many parameters.

When invoking a procedure list, the values are listed in the order in which the parameters are declared in the procedure. _________________________

The ____ mode type is considered constant because it cannot be changed within the procedure.

____are transactions created within another transaction.

A(n) database trigger performs tasks automatically when a particular application event occurs such as when a user clicks a button on the screen. _________________________

One important item that needs to be considered when creating stored procedures is to make them flexible so that they can be ____.

The term pragma refers to additional instructions for the PL/SQL compiler to use during program unit compilation.

The ____ command can be used to list details about the structure of a procedure, such as information regarding the parameters.

If no mode is indicated in a parameter, the default value of ____________________ is applied.

The ____________________ area of a block determines what happens if an error occurs.