Exam 5: Procedures

The values from the application that pass into parameters are called actual parameters; the parameters in the procedure declaration are called formal parameters.

With a(n) ____________________ only parameter, the parameter is empty when the procedure is invoked and a value is assigned to the parameter during the execution of the procedure and returned upon completion.

The RAISE_APPLICATION_ERROR function accepts the ____ arguments.

The reuse of code is an important contributor to programming efficiency.

____ are mechanisms used to send values into and out of a program unit.

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

A PL/SQL block that is created and named is known as a(n) named program unit. _________________________

A subprogram is created in the ____________________ section of the procedure block.

____ is an example of a function.

A(n) ____ must be assigned one of three available modes: IN, OUT, IN OUT.

The values from an application that pass into parameters are called formal parameters. _________________________

Three pieces of information for each parameter must be provided in the header: name, mode, and ____________________.

____ no longer exist after being executed.

A parameter with a(n) ____ only mode can receive a value, but this value cannot be changed in the procedure.

A(n) ____ contains a RETURN clause and is used to manipulate data and return a single resulting value.

The special syntax of =>> is used to accomplish named association.

A program unit that is defined within another program unit is called a subprogram.

Stored procedures are saved in an Oracle11g application or library on the client-side.

When creating a procedure, each parameter is listed, along with a mode and ____.

The ____________________ combined mode can achieve the passing of a value both into and out of a procedure with a single parameter.