Question 1

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

Accepted Answer

A) True 
 B)False

Question 2

An exception that has been declared must be referred to in the RAISE statement or a PL/SQL error will occur. _________________________

Accepted Answer

A) True 
 B)False

Question 3

Three arguments are required in a PRAGMA EXCEPTION_INIT statement.

Accepted Answer

A) True 
 B)False

Question 4

Which of the following statements is correct?

Accepted Answer

A)  An exception that has been declared must be referred to in the RAISE statement, or a PL/SQL error will occur. 
B)  An exception that has not been declared must be referred to in the RAISE statement, or a PL/SQL error will occur. 
C)  An exception that has been declared must not be referred to in the RAISE statement, or a PL/SQL error will occur. 
D)  An exception that has been declared must be referred to in the SELECT statement, or a PL/SQL error will occur. 
A)  An exception that has been declared must be referred to in the RAISE statement, or a PL/SQL error will occur. 
B)  An exception that has not been declared must be referred to in the RAISE statement, or a PL/SQL error will occur. 
C)  An exception that has been declared must not be referred to in the RAISE statement, or a PL/SQL error will occur. 
D)  An exception that has been declared must be referred to in the SELECT statement, or a PL/SQL error will occur.

Question 5

A(n) ____ represents a work area or section of memory in which an SQL statement is being processed in the Oracle server.

Accepted Answer

A)  collection 
B)  variable 
C)  cursor 
D)  nested table 
A)  collection 
B)  variable 
C)  cursor 
D)  nested table

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

An exception that has been declared must be referred to in the RAISE statement or a PL/SQL error will occur. _________________________

Three arguments are required in a PRAGMA EXCEPTION_INIT statement.

Which of the following statements is correct?

A(n) ____ represents a work area or section of memory in which an SQL statement is being processed in the Oracle server.

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

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

An exception that has been declared must be referred to in the RAISE statement or a PL/SQL error will occur. _________________________

Three arguments are required in a PRAGMA EXCEPTION_INIT statement.

Which of the following statements is correct?

A(n) ____ represents a work area or section of memory in which an SQL statement is being processed in the Oracle server.

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