Exam 4: Cursors and Exception Handling

Oracle supplies a set of ____ or names associated with common Oracle errors.

____ are values passed into the cursor when opened and used in the SELECT statement of the cursor to determine what value it will contain.

What can be used to simplify processing each row of a set retrieved from a database?

An attempted division by zero causes the ____________________ exception.

An attempted violation of a unique or primary key column constraint causes the ____________________ exception.

The ____________________ function returns the Oracle error number.

A FORALL statement can process a group of rows in a DML operation.

____ refers to a SELECT statement in a PL/SQL block that retrieves more than one row.

A cursor variable assigns a name to a work area holding a specific result set, whereas an explicit cursor is simply a pointer to a work area in which a query can be processed.

The ____ option specifies the number of rows to process as a group.

What is the difference between an explicit and an implicit cursor?

If the ____________________ clause of a SELECT statement contains either scalar or record variables and if more than one row is selected, the TOO_MANY_ROWS error is raised.

When processing many rows in a query, ____________________ can be used to improve performance.

Implicit and explicit cursors are considered dynamic because they are associated with specific queries.

____ are declared and manipulated in the PL/SQL block code for handling a set of rows returned by a SELECT statement.

A good programming practice is to include ____________________ in your code to document what is being accomplished throughout the program.

What is the difference between a predefined exception and a user-defined exception?

In Oracle, if the UPDATE statement does not affect any rows, an error is raised.

Because Oracle does not raise an error if a(n) UPDATE does not affect any rows, you must include specific instructions in the block to raise an error if no rows are updated. _________________________

The ____ action used with an explicit cursor clears the active set of rows and frees the memory area used for the cursor.