Exam 5: Procedures

The EXIT command can be used to remove procedures. _________________________

____________________ refers to the logical group of DML actions that is affected by a transaction control statement.

What is the difference between a database trigger and an application trigger?

The DBMS_OUTPUT statement is used to ____.

A(n) ____ performs tasks automatically when a DML action occurs on the table with which it is associated.

Three choices exist for parameter mode: INTO, OUT OF, and IN OUT.

____ are stored on the server.

Only the program unit in which a subprogram is declared can use that subprogram.

The ____ command can be used to remove procedures.

An application trigger performs a task automatically when a DML action occurs on the table with which it is associated.

If a table column data type is modified, no changes to associated variables are required because the ____ attribute always uses the column's current data type.

Program units are made flexible by using parameters, which are mechanisms to send values into and out of the program unit. _________________________

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

A(n) procedure is used to accomplish one or more tasks, return none or many values, and can be used only in PL/SQL statements. _________________________

The RAISE_APPLICATION_ERROR built-in function is provided by Oracle to ____.