Question 1

____________________ cannot be used in SQL statements.

Accepted Answer

The answer of ____________________ cannot be used in SQL statements....

Question 2

The term "passed by reference" means that the value is copied from the actual parameter to the formal parameter.

Accepted Answer

A) True 
 B)False

Question 3

The default behaviors of value passing can be overridden by using a compiler hint named NOCOPY. _________________________

Accepted Answer

A) True 
 B)False

Question 4

The term passed by reference implies that the value is copied from the actual parameter to the formal parameter. _________________________

Accepted Answer

A) True 
 B)False

Question 5

Functions used in SQL statements must meet all of the following requirements, except ____.

Accepted Answer

A)  Must be a stored database object 
B)  Can use only OUT parameters 
C)  Return data types must be a database data type 
D)  Cannot issue ALTER SESSION or ALTER SYSTEM commands 
A)  Must be a stored database object 
B)  Can use only OUT parameters 
C)  Return data types must be a database data type 
D)  Cannot issue ALTER SESSION or ALTER SYSTEM commands

Question 6

The ____ command is used to view parameter information.

Accepted Answer

A)  DROP 
B)  SET 
C)  DESC 
D)  OUT 
A)  DROP 
B)  SET 
C)  DESC 
D)  OUT

Question 7

Which of the following correctly creates a function that performs an update on the BB_TEST1 table?

Accepted Answer

A)  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; 
B)  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; 
C)  CREATE OR REPLACE FUNCTION fct_test1_sf (p_num)
RETURN NUMBER
IS
BEGIN
UPDATE bb_test1
RETURN p_num;
END; 
D)  CREATE OR REPLACE FUNCTION fct_test1_sf (p_num IN NUMBER(6))
RETURN NUMBER
IS
BEGIN
UPDATE bb_test1
SET col1 = p_num;
RETURN p_num
END 
A)  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; 
B)  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; 
C)  CREATE OR REPLACE FUNCTION fct_test1_sf (p_num)
RETURN NUMBER
IS
BEGIN
UPDATE bb_test1
RETURN p_num;
END; 
D)  CREATE OR REPLACE FUNCTION fct_test1_sf (p_num IN NUMBER(6))
RETURN NUMBER
IS
BEGIN
UPDATE bb_test1
SET col1 = p_num;
RETURN p_num
END

Question 8

You cannot include ____________________ information when declaring a formal parameter.

Accepted Answer

The answer of You cannot include ____________________ information when declaring...

Question 9

You can include multiple RETURN statements in the body of a function.

Accepted Answer

A) True 
 B)False

Question 10

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

Accepted Answer

A)  DECLARE
V_amt1 number(5,2);
V_amt2 number(3,0);
BEGIN
V_amt1 := 32.50;
V_amt2 := ROUND(v_amt1)
DBMS_OUTPUT.PUT_LINE(v_ amt2);
END; 
B)  DECLARE
V_amt1 number(5,2);
V_amt2 number(3,0);
BEGIN
V_amt1 := 32.50;
V_amt2 := ROUND(v_amt1,1);
DBMS_OUTPUT.PUT_LINE(v_ amt2);
END; 
C)  DECLARE
V_amt1 number(5,2);
V_amt2 number(3,0);
BEGIN
V_amt1 := 32.50;
V_amt2 := ROUND v_amt1, 2;
DBMS_OUTPUT.PUT_LINE(v_ amt2);
END; 
D)  DECLARE
V_amt1 number(5,2);
V_amt2 number(3,0);
BEGIN
V_amt1 := 32.50;
V_amt2 := ROUND[v_amt1,0];
DBMS_OUTPUT.PUT_LINE(v_ amt2);
END; 
A)  DECLARE
V_amt1 number(5,2);
V_amt2 number(3,0);
BEGIN
V_amt1 := 32.50;
V_amt2 := ROUND(v_amt1)
DBMS_OUTPUT.PUT_LINE(v_ amt2);
END; 
B)  DECLARE
V_amt1 number(5,2);
V_amt2 number(3,0);
BEGIN
V_amt1 := 32.50;
V_amt2 := ROUND(v_amt1,1);
DBMS_OUTPUT.PUT_LINE(v_ amt2);
END; 
C)  DECLARE
V_amt1 number(5,2);
V_amt2 number(3,0);
BEGIN
V_amt1 := 32.50;
V_amt2 := ROUND v_amt1, 2;
DBMS_OUTPUT.PUT_LINE(v_ amt2);
END; 
D)  DECLARE
V_amt1 number(5,2);
V_amt2 number(3,0);
BEGIN
V_amt1 := 32.50;
V_amt2 := ROUND[v_amt1,0];
DBMS_OUTPUT.PUT_LINE(v_ amt2);
END;

Question 11

In a(n) function, the RETURN statement includes no arguments and is followed with a semicolon. _________________________

Accepted Answer

A) True 
 B)False

____________________ cannot be used in SQL statements.

The term "passed by reference" means that the value is copied from the actual parameter to the formal parameter.

The default behaviors of value passing can be overridden by using a compiler hint named NOCOPY. _________________________

The term passed by reference implies that the value is copied from the actual parameter to the formal parameter. _________________________

Functions used in SQL statements must meet all of the following requirements, except ____.

The ____ command is used to view parameter information.

Which of the following correctly creates a function that performs an update on the BB_TEST1 table?

You cannot include ____________________ information when declaring a formal parameter.

You can include multiple RETURN statements in the body of a function.

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

In a(n) function, the RETURN statement includes no arguments and is followed with a semicolon. _________________________

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

____________________ cannot be used in SQL statements.

The term "passed by reference" means that the value is copied from the actual parameter to the formal parameter.

The default behaviors of value passing can be overridden by using a compiler hint named NOCOPY. _________________________

The term passed by reference implies that the value is copied from the actual parameter to the formal parameter. _________________________

Functions used in SQL statements must meet all of the following requirements, except ____.

The ____ command is used to view parameter information.

Which of the following correctly creates a function that performs an update on the BB_TEST1 table?

You cannot include ____________________ information when declaring a formal parameter.

You can include multiple RETURN statements in the body of a function.

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

In a(n) function, the RETURN statement includes no arguments and is followed with a semicolon. _________________________

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