Question 1

In PL/SQL, comment text is not executed.

Accepted Answer

A) True 
 B)False

Question 2

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

A) True 
 B)False

Question 3

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

Accepted Answer

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

Question 4

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

A) True 
 B)False

Question 5

Bulk processing options can have a detrimental effect on performance.

Accepted Answer

A) True 
 B)False

Question 6

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

A) True 
 B)False

Question 7

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

Accepted Answer

A)  FORALL 
B)  COLLECT BULK 
C)  BULK COLLECT 
D)  LIMIT 
A)  FORALL 
B)  COLLECT BULK 
C)  BULK COLLECT 
D)  LIMIT

Question 8

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

Accepted Answer

A) True 
 B)False

Question 9

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

Accepted Answer

A) True 
 B)False

Question 10

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

Accepted Answer

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

Question 11

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

Accepted Answer

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

Question 12

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

Accepted Answer

A)  WHERE 
B)  EXIT WHEN 
C)  WHEN OTHERS 
D)  EXCEPTION 
A)  WHERE 
B)  EXIT WHEN 
C)  WHEN OTHERS 
D)  EXCEPTION

Question 13

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

Accepted Answer

The answer of Because Oracle does not raise an error...

Question 14

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

Accepted Answer

A) True 
 B)False

Question 15

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

Accepted Answer

A) True 
 B)False

Question 16

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

Accepted Answer

user-defin

Question 17

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

Accepted Answer

A)  EXCEPTION 
B)  UPDATE 
C)  Exception handler 
D)  GOTO 
A)  EXCEPTION 
B)  UPDATE 
C)  Exception handler 
D)  GOTO

Question 18

____ is required in a PRAGMA EXCEPTION_INIT statement.

Accepted Answer

A)  LOOP 
B)  Exception name 
C)  Predefined error 
D)  INIT code 
A)  LOOP 
B)  Exception name 
C)  Predefined error 
D)  INIT code

Question 19

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

Accepted Answer

A)  TOO_MANY_ROWS 
B)  NO_DATA_FOUND 
C)  EXIT WHEN 
D)  WHEN OTHERS 
A)  TOO_MANY_ROWS 
B)  NO_DATA_FOUND 
C)  EXIT WHEN 
D)  WHEN OTHERS

Question 20

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

Accepted Answer

A) True 
 B)False

In PL/SQL, comment text is not executed.

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

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

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.

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

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

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

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

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

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

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) PRAGMA statement instructs Oracle to use some additional information provided when compiling and executing a block. _________________________

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

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

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

____ is required in a PRAGMA EXCEPTION_INIT statement.

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

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

In PL/SQL, comment text is not executed.

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

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

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.

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

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

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

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

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

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

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) PRAGMA statement instructs Oracle to use some additional information provided when compiling and executing a block. _________________________

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

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

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

____ is required in a PRAGMA EXCEPTION_INIT statement.

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

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