FiltersDone

Question type

Essay

Multiple Choice

Short Answer

True False

Matching

Exam 4: Cursors and Exception Handling

Show Answer

Share

---

All types

Filters

Study FlashcardsPractice ExamLearn

Question 21

Multiple Choice

Review LaterAdd Note

Review Later

The ____ action used with an explicit cursor creates a named cursor identified by a SELECT statement.

A) OPEN
B) DECLARE
C) FETCH
D) CLOSE

Correct Answer

verified

Show Answer

Question 22

True/False

Review LaterAdd Note

Review Later

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

Correct Answer

verified

Show Answer

Question 23

True/False

Review LaterAdd Note

Bulk processing options can have a detrimental effect on performance.

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

A(n) PRAGMA statement instructs Oracle to use some additional information provided when compiling and executing a block. _________________________

In PL/SQL, comment text is not executed.

Explicit cursors are declared automatically for all DML and SELECT statements issued within a PL/SQL block.

You can process multiple rows of data from a database by creating explicit cursors.

The ____ handler should always be the last handler listed in the EXCEPTION section of a block.

____ refers to an attempted violation of a unique or primary key column constraint.

If the INTO 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. _________________________

The RAISE_APPLICATION_ERROR is an Oracle built-in procedure that allows the developer to associate their own error number and message to an error. _________________________

A(n) ____ is a mechanism to trap an error that occurs in processing.

____ is used to trap errors not specifically addressed in one of the exception handlers.

____ is required in a PRAGMA EXCEPTION_INIT statement.

The ____ option groups rows of queries or DML statements for processing.

____ refers to a condition where there is no WHEN clause in the CASE statement.

Because Oracle does not raise an error if a(n) ____________________ does not affect any rows, you must include specific instructions in the block.

A(n) ____________________ is one that a developer explicitly raises in the block to enforce a business rule.

Some cursor variables are references or pointers to a specific work area.