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

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

A) NO_DATA_FOUND
B) TOO_MANY_ROWS
C) DUP_VAL_ON_INDEX
D) CASE_NOT_FOUND

E) A) and C)
F) All of the above

Correct Answer

verified

Show Answer

Question 22

Short Answer

Review LaterAdd Note

Review Later

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

Correct Answer

verified

Show Answer

Question 23

Multiple Choice

Review LaterAdd Note

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

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

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

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 one that a developer explicitly raises in the block to enforce a business rule.

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

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

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

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

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

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

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

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. _________________________

Bulk processing options can have a detrimental effect on performance.

In PL/SQL, comment text is not executed.

____ is required in a PRAGMA EXCEPTION_INIT statement.

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

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