Question 1

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

Accepted Answer

Implicit and explicit cursors are not considered dynamic because they are associated with predefined SQL statements at compile time, not constructed dynamically at runtime.

Question 2

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.

Accepted Answer

This statement is incorrect. An explicit cursor is a named resource that holds the results of a SELECT statement, whereas a cursor variable is a reference to a cursor that is not named.

Question 3

In PL/SQL, comment text is not executed.

Accepted Answer

PL/SQL comment text is ignored by the compiler and is used to provide information or explanation about the code.

Question 4

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

Accepted Answer

A FORALL statement is used to perform DML operations on a group of rows. It is used to improve the performance of DML operations by reducing context switching between the PL/SQL engine and the SQL engine.

Question 5

Bulk processing options can have a detrimental effect on performance.

Accepted Answer

Bulk processing options are generally designed to improve performance by reducing the overhead associated with processing individual items one at a time.

Question 6

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

Accepted Answer

If the UPDATE statement doesn't affect any rows, there will be no error raised. It will simply return a message saying "0 rows updated."

Question 7

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

Accepted Answer

Cursor variables can be references or pointers to a specific work area that can be used to manipulate data.

Question 8

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

Accepted Answer

Explicit cursors need to be declared explicitly using the CURSOR statement, they are not declared automatically for DML and SELECT statements.

Question 9

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

Accepted Answer

Explicit cursors are used to process multiple rows of data from a database in a procedural manner. They allow fetching of multiple rows from a result set and iterating over them to perform certain actions. Therefore, the given statement is true.

Question 10

Implicit cursors are considered static because they are associated with specific queries. _________________________

Accepted Answer

Implicit cursors are automatically created by the database system for single SQL statements and are tied to the specific query executed, making them static in nature.

Question 11

Three arguments are required in a PRAGMA EXCEPTION_INIT statement.

Accepted Answer

PRAGMA EXCEPTION_INIT only requires two arguments: the exception name and the error number.

Question 12

When referencing SQL attributes, the attribute information always reflects the information from the most recent SQL statement processed.

Accepted Answer

SQL attributes are updated with the most recent SQL statement processed, therefore the attribute information always reflects the most recent statement.

Question 13

An exception is a mechanism to trap an error that occurs in processing.

Accepted Answer

The answer of An exception is a mechanism to trap...

Question 14

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

Accepted Answer

, Explicit

Question 15

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

Accepted Answer

When the INTO clause of a SELECT statement contains a scalar or record variable, it can only receive one row of output. If more than one row is selected, the TOO_MANY_ROWS error is raised.

Question 16

A SELECT statement within a PL/SQL block has the possibility of raising the NO_DATA_FOUND exception.

Accepted Answer

If a SELECT statement within a PL/SQL block does not return any rows, the NO_DATA_FOUND exception is raised.

Question 17

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

Accepted Answer

A PRAGMA statement can provide additional instructions to Oracle during compilation and execution of a block.

Question 18

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

Accepted Answer

Implicit cursors are automatically created by Oracle whenever an SQL statement is executed, without the need for explicit declaration or manipulation by the developer.

Question 19

A(n) EXCEPTION statement within a PL/SQL block has the possibility of raising the NO_DATA_FOUND or TOO_MANY_ROWS exception. _________________________

Accepted Answer

, SELECT

Question 20

In PL/SQL, if a SELECT statement returns no rows, Oracle does not return an error.

Accepted Answer

In PL/SQL, if a SELECT statement is expected to return exactly one row but returns no rows, Oracle raises the NO_DATA_FOUND exception.

Quiz 4: Cursors and Exception Handling