Question 1

The error message argument of the RAISE_APPLICATION_ERROR function can accept up to ____ characters.

Accepted Answer

A)  300 
B)  450 
C)  512 
D)  600 
A)  300 
B)  450 
C)  512 
D)  600

Question 2

The term ____ refers to program code that resides on the user machine.

Accepted Answer

A)  client-side 
B)  client/server 
C)  two-tier 
D)  server-side 
A)  client-side 
B)  client/server 
C)  two-tier 
D)  server-side

Question 3

Which of the following statements is True?

Accepted Answer

A)  If an exception is raised in procedure B that has been called from procedure A, the control initially moves to the exception handler section of procedure B. 
B)  If an exception is raised in procedure B that has been called from procedure A, the control initially moves to the BEGIN section of procedure B. 
C)  If an exception is raised in procedure B that has been called from procedure A, the control initially moves to the exception handler section of procedure A. 
D)  If an exception is raised in procedure B that has been called from procedure A, the control initially moves to the header section of procedure B. 
A)  If an exception is raised in procedure B that has been called from procedure A, the control initially moves to the exception handler section of procedure B. 
B)  If an exception is raised in procedure B that has been called from procedure A, the control initially moves to the BEGIN section of procedure B. 
C)  If an exception is raised in procedure B that has been called from procedure A, the control initially moves to the exception handler section of procedure A. 
D)  If an exception is raised in procedure B that has been called from procedure A, the control initially moves to the header section of procedure B.

Question 4

Stored procedures and functions are saved in an Oracle11g application or library on the client-side. _________________________

Accepted Answer

A) True 
 B)False

Question 5

The DBMS_OUTPUT.PUT_LINE statement can be used to ____.

Accepted Answer

A)  assist with the creation of a cursor 
B)  assist with the creation of an exception 
C)  assist with creating functions 
D)  assist with debugging your code 
A)  assist with the creation of a cursor 
B)  assist with the creation of an exception 
C)  assist with creating functions 
D)  assist with debugging your code

Question 6

If values are calculated or retrieved from the database within the procedure, ____ parameters are used to return these values to the calling environment.

Accepted Answer

A)  IN 
B)  OUT 
C)  IN OUT 
D)  INOUT 
A)  IN 
B)  OUT 
C)  IN OUT 
D)  INOUT

Question 7

____________________ indicate which way the value provided for the parameter flows: into the procedure, out of the procedure, or both.

Accepted Answer

The answer of ____________________ indicate which way the value provided...

Question 8

The special syntax of := is used to accomplish named association. _________________________

Accepted Answer

A) True 
 B)False

Question 9

What information must be provided in the header section of a PL/SQL block for each parameter? Provide an explanation for each.

Accepted Answer

Three pieces of information for each par

Question 10

The term program unit implies that we typically create blocks of code to perform specific tasks that may be needed within a number of applications. _________________________

Accepted Answer

A) True 
 B)False

Question 11

____ are saved in an Oracle11g application or library on the client-side.

Accepted Answer

A)  Stored procedure and functions 
B)  Functions 
C)  Packages 
D)  Application procedures 
A)  Stored procedure and functions 
B)  Functions 
C)  Packages 
D)  Application procedures

Question 12

____ is an acceptable error number for the RAISE_APPLICATION_ERROR function.

Accepted Answer

A)  -18,000 
B)  -19,000 
C)  -20,002 
D)  -21,000 
A)  -18,000 
B)  -19,000 
C)  -20,002 
D)  -21,000

Question 13

Exception handling refers to the logical group of DML actions that is affected by a transaction control statement.

Accepted Answer

A) True 
 B)False

Question 14

____________________ is the process of identifying and removing errors from within program code.

Accepted Answer

The answer of ____________________ is the process of identifying and...

Question 15

The following code is considered to be a ____. CREATE OR REPLACE PROCEDURE total_calc_sp
(p_basket IN bb_basket.idbasket%TYPE,
P_total OUT bb_basket.total%TYPE := 0 )
IS

Accepted Answer

A)  function header section 
B)  PL/SQL block 
C)  procedure header section 
D)  DECLARE section 
A)  function header section 
B)  PL/SQL block 
C)  procedure header section 
D)  DECLARE section

Question 16

In the following code fragment, the IS keyword indicates that the ____. CREATE OR REPLACE PROCEDURE total_calc_sp
(p_basket IN bb_basket.idbasket%TYPE,
P_total OUT bb_basket.total%TYPE := 0 )
IS

Accepted Answer

A)  executable section follows 
B)  exception handlers follow 
C)  PL/SQL block follows 
D)  function follows 
A)  executable section follows 
B)  exception handlers follow 
C)  PL/SQL block follows 
D)  function follows

Question 17

A PL/SQL block created and named is a named program unit or subprogram.

Accepted Answer

A) True 
 B)False

Question 18

A(n) application trigger performs tasks automatically when a DML action occurs on the table with which it is associated. _________________________

Accepted Answer

A) True 
 B)False

Question 19

____ a program unit or PL/SQL block of code allows the storage and reuse of the code.

Accepted Answer

A)  Naming 
B)  Processing 
C)  Creating 
D)  Debugging 
A)  Naming 
B)  Processing 
C)  Creating 
D)  Debugging

Question 20

Exception handling is the process of identifying and removing errors from within program code.

Accepted Answer

A) True 
 B)False

The error message argument of the RAISE_APPLICATION_ERROR function can accept up to ____ characters.

The term ____ refers to program code that resides on the user machine.

Which of the following statements is True?

Stored procedures and functions are saved in an Oracle11g application or library on the client-side. _________________________

The DBMS_OUTPUT.PUT_LINE statement can be used to ____.

If values are calculated or retrieved from the database within the procedure, ____ parameters are used to return these values to the calling environment.

____________________ indicate which way the value provided for the parameter flows: into the procedure, out of the procedure, or both.

The special syntax of := is used to accomplish named association. _________________________

What information must be provided in the header section of a PL/SQL block for each parameter? Provide an explanation for each.

The term program unit implies that we typically create blocks of code to perform specific tasks that may be needed within a number of applications. _________________________

____ are saved in an Oracle11g application or library on the client-side.

____ is an acceptable error number for the RAISE_APPLICATION_ERROR function.

Exception handling refers to the logical group of DML actions that is affected by a transaction control statement.

____________________ is the process of identifying and removing errors from within program code.

The following code is considered to be a ____. CREATE OR REPLACE PROCEDURE total_calc_sp (p_basket IN bb_basket.idbasket%TYPE, P_total OUT bb_basket.total%TYPE := 0 ) IS

In the following code fragment, the IS keyword indicates that the ____. CREATE OR REPLACE PROCEDURE total_calc_sp (p_basket IN bb_basket.idbasket%TYPE, P_total OUT bb_basket.total%TYPE := 0 ) IS

A PL/SQL block created and named is a named program unit or subprogram.

A(n) application trigger performs tasks automatically when a DML action occurs on the table with which it is associated. _________________________

____ a program unit or PL/SQL block of code allows the storage and reuse of the code.

Exception handling is the process of identifying and removing errors from within program code.

Introduction To PL/SQL

Basic PL/SQL Block Structures

Handling Data In PL/SQL Blocks

Cursors and Exception Handling

Functions

PL/SQL Packages

Program Unit Dependencies

Database Triggers

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

Filters

Exam 5: Procedures

The error message argument of the RAISE_APPLICATION_ERROR function can accept up to ____ characters.

The term ____ refers to program code that resides on the user machine.

Which of the following statements is True?

Stored procedures and functions are saved in an Oracle11g application or library on the client-side. _________________________

The DBMS_OUTPUT.PUT_LINE statement can be used to ____.

If values are calculated or retrieved from the database within the procedure, ____ parameters are used to return these values to the calling environment.

____________________ indicate which way the value provided for the parameter flows: into the procedure, out of the procedure, or both.

The special syntax of := is used to accomplish named association. _________________________

What information must be provided in the header section of a PL/SQL block for each parameter? Provide an explanation for each.

The term program unit implies that we typically create blocks of code to perform specific tasks that may be needed within a number of applications. _________________________

____ are saved in an Oracle11g application or library on the client-side.

____ is an acceptable error number for the RAISE_APPLICATION_ERROR function.

Exception handling refers to the logical group of DML actions that is affected by a transaction control statement.

____________________ is the process of identifying and removing errors from within program code.

The following code is considered to be a ____. CREATE OR REPLACE PROCEDURE total_calc_sp (p_basket IN bb_basket.idbasket%TYPE, P_total OUT bb_basket.total%TYPE := 0 ) IS

In the following code fragment, the IS keyword indicates that the ____. CREATE OR REPLACE PROCEDURE total_calc_sp (p_basket IN bb_basket.idbasket%TYPE, P_total OUT bb_basket.total%TYPE := 0 ) IS

A PL/SQL block created and named is a named program unit or subprogram.

A(n) application trigger performs tasks automatically when a DML action occurs on the table with which it is associated. _________________________

____ a program unit or PL/SQL block of code allows the storage and reuse of the code.

Exception handling is the process of identifying and removing errors from within program code.

Introduction To PL/SQL

Basic PL/SQL Block Structures

Handling Data In PL/SQL Blocks

Cursors and Exception Handling

Functions

PL/SQL Packages

Program Unit Dependencies

Database Triggers

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

Filters