Question 1

____ refers to a SELECT statement in a PL/SQL block that retrieves no rows.

Accepted Answer

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

Question 2

Predefined exceptions are declared in the ____________________ package, which makes these globally available on the system.

Accepted Answer

STANDARD

Question 3

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

Accepted Answer

A) True 
 B)False  True

Question 4

Which of the following statements is correct?

Accepted Answer

A)  The value of the SQLCODE can be used directly in an SQL statement. 
B)  The value of the SQLCODE is assigned to a variable. 
C)  The value of the SQLCODE can not be assigned to a variable. 
D)  The value of the SQLERRM can be used directly in an SQL statement. 
A)  The value of the SQLCODE can be used directly in an SQL statement. 
B)  The value of the SQLCODE is assigned to a variable. 
C)  The value of the SQLCODE can not be assigned to a variable. 
D)  The value of the SQLERRM can be used directly in an SQL statement.

Question 5

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

Accepted Answer

A) True 
 B)False

Question 6

An error raised in the executable section of a block immediately moves processing to the EXCEPTION section of the block in search of an exception handler. _________________________

Accepted Answer

A) True 
 B)False

Question 7

The SQLCODE function returns the Oracle error message. _________________________

Accepted Answer

A) True 
 B)False

Question 8

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

Accepted Answer

A) True 
 B)False

Question 9

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

Accepted Answer

A) True 
 B)False

Question 10

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

Accepted Answer

The answer of A(n) ____________________ statement within a PL/SQL block...

Question 11

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

Accepted Answer

A)  predefined exception 
B)  exception 
C)  user-defined exception 
D)  error 
A)  predefined exception 
B)  exception 
C)  user-defined exception 
D)  error

Question 12

The ____ is an Oracle built-in procedure that allows developers to associate their own error number and message to an error.

Accepted Answer

A)  SQLCODE 
B)  SQLERRM 
C)  RAISE_APPLICATION_ERROR 
D)  WHEN OTHERS 
A)  SQLCODE 
B)  SQLERRM 
C)  RAISE_APPLICATION_ERROR 
D)  WHEN OTHERS

Question 13

The SQLERRM function returns the Oracle error number. _________________________

Accepted Answer

A) True 
 B)False

Question 14

The ____ action used in an explicit cursor processes the query and creates an active set of rows available in the cursor.

Accepted Answer

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

Question 15

Discuss the meaning of the term exception handler.

Accepted Answer

An exception handler is a mechanism to t

Question 16

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

Accepted Answer

A)  Implicit cursors 
B)  Index-by Tables 
C)  Assignment statements 
D)  Collections 
A)  Implicit cursors 
B)  Index-by Tables 
C)  Assignment statements 
D)  Collections

Question 17

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

A) True 
 B)False

Question 18

____ has the possibility of raising the NO_DATA_FOUND or TOO_MANY_ROWS exception.

Accepted Answer

A)  DECLARE 
B)  SELECT 
C)  CASE 
D)  LOOP 
A)  DECLARE 
B)  SELECT 
C)  CASE 
D)  LOOP

Question 19

____ returns the Oracle error message.

Accepted Answer

A)  EXIT WHEN 
B)  SQLCODE 
C)  SQLERR 
D)  SQLERRM 
A)  EXIT WHEN 
B)  SQLCODE 
C)  SQLERR 
D)  SQLERRM

Question 20

The ____ section of a PL/SQL block addresses two situations: either an Oracle error is raised or a user-defined error is raised.

Accepted Answer

A)  DECLARE 
B)  BEGIN 
C)  EXCEPTION 
D)  UPDATE 
A)  DECLARE 
B)  BEGIN 
C)  EXCEPTION 
D)  UPDATE

____ refers to a SELECT statement in a PL/SQL block that retrieves no rows.

Predefined exceptions are declared in the ____________________ package, which makes these globally available on the system.

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

Which of the following statements is correct?

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

An error raised in the executable section of a block immediately moves processing to the EXCEPTION section of the block in search of an exception handler. _________________________

The SQLCODE function returns the Oracle error message. _________________________

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

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

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

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

The ____ is an Oracle built-in procedure that allows developers to associate their own error number and message to an error.

The SQLERRM function returns the Oracle error number. _________________________

The ____ action used in an explicit cursor processes the query and creates an active set of rows available in the cursor.

Discuss the meaning of the term exception handler.

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

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

____ has the possibility of raising the NO_DATA_FOUND or TOO_MANY_ROWS exception.

____ returns the Oracle error message.

The ____ section of a PL/SQL block addresses two situations: either an Oracle error is raised or a user-defined error is raised.

Introduction To PL/SQL

Basic PL/SQL Block Structures

Handling Data In PL/SQL Blocks

Procedures

Functions

PL/SQL Packages

Program Unit Dependencies

Database Triggers

Oracle-Supplied Packages, Dynamic SQL, and Hiding Source Code

Filters

Exam 4: Cursors and Exception Handling

____ refers to a SELECT statement in a PL/SQL block that retrieves no rows.

Predefined exceptions are declared in the ____________________ package, which makes these globally available on the system.

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

Which of the following statements is correct?

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

An error raised in the executable section of a block immediately moves processing to the EXCEPTION section of the block in search of an exception handler. _________________________

The SQLCODE function returns the Oracle error message. _________________________

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

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

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

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

The ____ is an Oracle built-in procedure that allows developers to associate their own error number and message to an error.

The SQLERRM function returns the Oracle error number. _________________________

The ____ action used in an explicit cursor processes the query and creates an active set of rows available in the cursor.

Discuss the meaning of the term exception handler.

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

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

____ has the possibility of raising the NO_DATA_FOUND or TOO_MANY_ROWS exception.

____ returns the Oracle error message.

The ____ section of a PL/SQL block addresses two situations: either an Oracle error is raised or a user-defined error is raised.

Introduction To PL/SQL

Basic PL/SQL Block Structures

Handling Data In PL/SQL Blocks

Procedures

Functions

PL/SQL Packages

Program Unit Dependencies

Database Triggers

Oracle-Supplied Packages, Dynamic SQL, and Hiding Source Code

Filters