Question 1

A(n) ____________________ cannot serve as an entire statement.

Accepted Answer

Function

Question 2

Deleting a program unit can be accomplished by issuing a(n) DEL command. _________________________

Accepted Answer

A) True 
 B)False  False

Question 3

The term ____ is identified with a set of acronyms that indicate the restrictions on using the function.

Accepted Answer

A)  compiler hint 
B)  purity level 
C)  pass by reference 
D)  pass by value 
A)  compiler hint 
B)  purity level 
C)  pass by reference 
D)  pass by value B

Question 4

What are the main differences between a function and a procedure?

Accepted Answer

The main difference between functions an

Question 5

It is considered good form to return only one value from a function and to do so using the ____________________ statement.

Accepted Answer

The answer of It is considered good form to return...

Question 6

Which of the following code fragments would not raise an error?

Accepted Answer

A)  CREATE OR REPLACE FUNCTION ship_calc(p_qty IN NUMBER)
IS
Lv_ship_num NUMBER(5,2);
BEGIN
IF p_qty > 10 THEN
Lv_ship_num := 11.00;
ELSE
Lv_ship_num := 5.00;
END IF;
RETURN lv_ship_num;
END; 
B)  CREATE OR REPLACE ship_calc(p_qty)
RETURN NUMBER
IS
Lv_ship_num NUMBER(5,2);
BEGIN
IF p_qty > 10 THEN
Lv_ship_num := 11.00;
ELSE
Lv_ship_num := 5.00;
ENDIF;
RETURN lv_ship_num;
END; 
C)  CREATE OR REPLACE FUNCTION ship_calc(p_qty IN NUMBER)
RETURN NUMBER
IS
Lv_ship_num NUMBER(5,2);
BEGIN
IF p_qty > 10 THEN
Lv_ship_num := 11.00;
ELSE
Lv_ship_num := 5.00;
END IF;
RETURN lv_ship_num;
END; 
D)  CREATE OR REPLACE FUNCTION ship_calc(p_qty IN NUMBER)
RETURN NUMBER
BEGIN
IF p_qty > 10 THEN
Lv_ship_num := 11.00;
ELSE
Lv_ship_num := 5.00;
END IF;
RETURN lv_ship_num;
END; 
A)  CREATE OR REPLACE FUNCTION ship_calc(p_qty IN NUMBER)
IS
Lv_ship_num NUMBER(5,2);
BEGIN
IF p_qty > 10 THEN
Lv_ship_num := 11.00;
ELSE
Lv_ship_num := 5.00;
END IF;
RETURN lv_ship_num;
END; 
B)  CREATE OR REPLACE ship_calc(p_qty)
RETURN NUMBER
IS
Lv_ship_num NUMBER(5,2);
BEGIN
IF p_qty > 10 THEN
Lv_ship_num := 11.00;
ELSE
Lv_ship_num := 5.00;
ENDIF;
RETURN lv_ship_num;
END; 
C)  CREATE OR REPLACE FUNCTION ship_calc(p_qty IN NUMBER)
RETURN NUMBER
IS
Lv_ship_num NUMBER(5,2);
BEGIN
IF p_qty > 10 THEN
Lv_ship_num := 11.00;
ELSE
Lv_ship_num := 5.00;
END IF;
RETURN lv_ship_num;
END; 
D)  CREATE OR REPLACE FUNCTION ship_calc(p_qty IN NUMBER)
RETURN NUMBER
BEGIN
IF p_qty > 10 THEN
Lv_ship_num := 11.00;
ELSE
Lv_ship_num := 5.00;
END IF;
RETURN lv_ship_num;
END;

Question 7

The RETURN statement in a function is used to control the flow of execution.

Accepted Answer

A) True 
 B)False

Question 8

A(n) procedure is one type of program unit that is used to accomplish one or more tasks, return none or many values, and is used only in PL/SQL statements. _________________________

Accepted Answer

A) True 
 B)False

Question 9

Deleting a program unit can be accomplished by issuing a(n) ____________________ command.

Accepted Answer

The answer of Deleting a program unit can be accomplished...

Question 10

____ refer to the parameters that are listed in the program unit.

Accepted Answer

A)  Modes 
B)  Functions 
C)  Procedures 
D)  Formal parameters 
A)  Modes 
B)  Functions 
C)  Procedures 
D)  Formal parameters

Question 11

Discuss the techniques available in PL/SQL for passing values between actual parameters and formal parameters.

Accepted Answer

PL/SQL uses two techniques for passing v

Question 12

A function is quite similar to a procedure in that it is a program unit that achieves a task, can receive input values, and returns values to the calling environment.

Accepted Answer

A) True 
 B)False

Question 13

What are formal and actual parameters?

Accepted Answer

The term formal parameters ref

Question 14

A good method to handle the size issue when declaring variables that hold values from a database table is to use the ____ attribute to use the size of the database column.

Accepted Answer

A)  NOCOPY 
B)  %TYPE 
C)  > 
D)  TYPE 
A)  NOCOPY 
B)  %TYPE 
C)  > 
D)  TYPE

Question 15

The task of the ____________________ function is to use the two arguments provided, a numeric value and the degree of rounding, and return the resulting value.

Accepted Answer

The answer of The task of the ____________________ function is...

Question 16

The ____ purity level does not modify database tables.

Accepted Answer

A)  WNDS 
B)  WNPS 
C)  RNPS 
D)  RNDS 
A)  WNDS 
B)  WNPS 
C)  RNPS 
D)  RNDS

Question 17

At least one ____ statement must be included in a function body to instruct which value to return.

Accepted Answer

A)  CREATE 
B)  RETURN 
C)  BEGIN 
D)  EXCEPTION 
A)  CREATE 
B)  RETURN 
C)  BEGIN 
D)  EXCEPTION

Question 18

Which of the following statements is True?

Accepted Answer

A)  After IN OUT parameters are included in functions, the function can no longer be used in SQL statements. 
B)  After OUT parameters are included in functions, the function can no longer be used in SQL statements. 
C)  After INOUT parameters are included in functions, the function can no longer be used in SQL statements. 
D)  After IN parameters are included in functions, the function can no longer be used in SQL statements. 
A)  After IN OUT parameters are included in functions, the function can no longer be used in SQL statements. 
B)  After OUT parameters are included in functions, the function can no longer be used in SQL statements. 
C)  After INOUT parameters are included in functions, the function can no longer be used in SQL statements. 
D)  After IN parameters are included in functions, the function can no longer be used in SQL statements.

Question 19

You cannot include data type information when declaring a formal parameter. ________________________

Accepted Answer

A) True 
 B)False

Question 20

In the code below, which of the following is the parameter variable?
CREATE OR REPLACE FUNCTION fct_test1_sf (p_num IN NUMBER)
RETURN NUMBER
IS
BEGIN
UPDATE bb_test1
SET col1 = p_num;
RETURN p_num;
END;

Accepted Answer

A)  bb_test1 
B)  col1 
C)  p_num 
D)  fct_test1_sf 
A)  bb_test1 
B)  col1 
C)  p_num 
D)  fct_test1_sf

A(n) ____________________ cannot serve as an entire statement.

Deleting a program unit can be accomplished by issuing a(n) DEL command. _________________________

The term ____ is identified with a set of acronyms that indicate the restrictions on using the function.

What are the main differences between a function and a procedure?

It is considered good form to return only one value from a function and to do so using the ____________________ statement.

Which of the following code fragments would not raise an error?

The RETURN statement in a function is used to control the flow of execution.

A(n) procedure is one type of program unit that is used to accomplish one or more tasks, return none or many values, and is used only in PL/SQL statements. _________________________

Deleting a program unit can be accomplished by issuing a(n) ____________________ command.

____ refer to the parameters that are listed in the program unit.

Discuss the techniques available in PL/SQL for passing values between actual parameters and formal parameters.

A function is quite similar to a procedure in that it is a program unit that achieves a task, can receive input values, and returns values to the calling environment.

What are formal and actual parameters?

A good method to handle the size issue when declaring variables that hold values from a database table is to use the ____ attribute to use the size of the database column.

The task of the ____________________ function is to use the two arguments provided, a numeric value and the degree of rounding, and return the resulting value.

The ____ purity level does not modify database tables.

At least one ____ statement must be included in a function body to instruct which value to return.

Which of the following statements is True?

You cannot include data type information when declaring a formal parameter. ________________________

In the code below, which of the following is the parameter variable? CREATE OR REPLACE FUNCTION fct_test1_sf (p_num IN NUMBER) RETURN NUMBER IS BEGIN UPDATE bb_test1 SET col1 = p_num; RETURN p_num; END;

Introduction To PL/SQL

Basic PL/SQL Block Structures

Handling Data In PL/SQL Blocks

Cursors and Exception Handling

Procedures

PL/SQL Packages

Program Unit Dependencies

Database Triggers

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

Filters

Exam 6: Functions

A(n) ____________________ cannot serve as an entire statement.

Deleting a program unit can be accomplished by issuing a(n) DEL command. _________________________

The term ____ is identified with a set of acronyms that indicate the restrictions on using the function.

What are the main differences between a function and a procedure?

It is considered good form to return only one value from a function and to do so using the ____________________ statement.

Which of the following code fragments would not raise an error?

The RETURN statement in a function is used to control the flow of execution.

A(n) procedure is one type of program unit that is used to accomplish one or more tasks, return none or many values, and is used only in PL/SQL statements. _________________________

Deleting a program unit can be accomplished by issuing a(n) ____________________ command.

____ refer to the parameters that are listed in the program unit.

Discuss the techniques available in PL/SQL for passing values between actual parameters and formal parameters.

A function is quite similar to a procedure in that it is a program unit that achieves a task, can receive input values, and returns values to the calling environment.

What are formal and actual parameters?

A good method to handle the size issue when declaring variables that hold values from a database table is to use the ____ attribute to use the size of the database column.

The task of the ____________________ function is to use the two arguments provided, a numeric value and the degree of rounding, and return the resulting value.

The ____ purity level does not modify database tables.

At least one ____ statement must be included in a function body to instruct which value to return.

Which of the following statements is True?

You cannot include data type information when declaring a formal parameter. ________________________

In the code below, which of the following is the parameter variable? CREATE OR REPLACE FUNCTION fct_test1_sf (p_num IN NUMBER) RETURN NUMBER IS BEGIN UPDATE bb_test1 SET col1 = p_num; RETURN p_num; END;

Introduction To PL/SQL

Basic PL/SQL Block Structures

Handling Data In PL/SQL Blocks

Cursors and Exception Handling

Procedures

PL/SQL Packages

Program Unit Dependencies

Database Triggers

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

Filters