Exam 6: Functions

How many input values does the following code require? CREATE OR REPLACE FUNCTION memfmt1_sf (p_id IN NUMBER, P_first IN VARCHAR2, P_last IN VARCHAR2) RETURN VARCHAR2 IS Lv_mem_txt VARCHAR2(35); BEGIN Lv_mem_txt := 'Member ' ||p_id|| ' - ' ||p_first|| ' ' ||p_last; RETURN lv_mem_txt; END;

(Multiple Choice)

4.8/5

(74)

Question 21

____ refer to the arguments that are used when calling or invoking the program unit.

(Multiple Choice)

4.8/5

(67)

Question 22

The following is a correct example of the use of the DROP command. DROP function_name;

(True/False)

4.8/5

(78)

Question 23

A(n) procedure is part of an expression and cannot serve an entire statement. ____________________

(True/False)

4.8/5

(84)

Question 24

It is possible to reference a data dictionary to determine what code is contained in a program unit.

(True/False)

4.9/5

(85)

Question 25

The following code is an example of a(n) ____. DECLARE Lv_name_txt VARCHAR2(35); Lv_id_num NUMBER(4) := 25; Lv_first_txt VARCHAR2(15) := 'Scott'; Lv_last_txt VARCHAR2(20) := 'David'; BEGIN Lv_name_txt := memfmt1_sf(lv_id_num,lv_first_txt, lv_last_txt); DBMS_OUTPUT.PUT_LINE(lv_name_txt); END;

(Multiple Choice)

4.8/5

(74)

Question 26

Formal parameters including the RETURN data type cannot include size information.

(True/False)

4.8/5

(84)

Question 27

The term "passed by value" means that a pointer to the value in the actual parameter is created instead of copying the value from the actual parameter to the formal parameter.

(True/False)

4.9/5

(90)

Question 28

The term passed by value implies that a pointer to the value in the actual parameter is created instead of copying the value from the actual parameter to the formal parameter. _________________________

(True/False)

4.8/5

(83)

Question 29

Procedures can be used in SQL statements.

(True/False)

4.8/5

(90)

Question 30

All of the following are purity level acronyms, except ____.

(Multiple Choice)

4.9/5

(65)

Question 31

The main difference between functions and procedures is that a function is part of an expression.

(True/False)

4.8/5

(86)

Question 32

Functions cannot be used in a(n) CHECK constraint or as a default value of a table column. _________________________

(True/False)

4.8/5

(74)

Question 33

The RETURN statement can return constant values, such as a text string.

(True/False)

4.7/5

(69)

Question 34

The term "actual parameters" refers to the parameters that are listed in the program unit.

(True/False)

4.9/5

(72)

Question 35

A(n) procedure cannot be invoked in a standalone fashion. _________________________

(True/False)

4.8/5

(66)

Question 36

The term "formal parameters" refers to the arguments that are used when calling or invoking the program unit.

(True/False)

4.9/5

(81)

Question 37

A(n) ____ is a request a programmer includes within his or her code that asks Oracle to modify the default processing in some manner.

(Multiple Choice)

4.8/5

(75)

Question 38

Which of the following statements is incorrect?

(Multiple Choice)

4.9/5

(79)

Question 39

All of the following represent restrictions on functions, except ____.

(Multiple Choice)

4.7/5

(88)

Question 40

Showing 21 - 40 of 51

How many input values does the following code require? CREATE OR REPLACE FUNCTION memfmt1_sf (p_id IN NUMBER, P_first IN VARCHAR2, P_last IN VARCHAR2) RETURN VARCHAR2 IS Lv_mem_txt VARCHAR2(35); BEGIN Lv_mem_txt := 'Member ' ||p_id|| ' - ' ||p_first|| ' ' ||p_last; RETURN lv_mem_txt; END;

____ refer to the arguments that are used when calling or invoking the program unit.

The following is a correct example of the use of the DROP command. DROP function_name;

A(n) procedure is part of an expression and cannot serve an entire statement. ____________________

It is possible to reference a data dictionary to determine what code is contained in a program unit.

The following code is an example of a(n) ____. DECLARE Lv_name_txt VARCHAR2(35); Lv_id_num NUMBER(4) := 25; Lv_first_txt VARCHAR2(15) := 'Scott'; Lv_last_txt VARCHAR2(20) := 'David'; BEGIN Lv_name_txt := memfmt1_sf(lv_id_num,lv_first_txt, lv_last_txt); DBMS_OUTPUT.PUT_LINE(lv_name_txt); END;

Formal parameters including the RETURN data type cannot include size information.

The term "passed by value" means that a pointer to the value in the actual parameter is created instead of copying the value from the actual parameter to the formal parameter.

The term passed by value implies that a pointer to the value in the actual parameter is created instead of copying the value from the actual parameter to the formal parameter. _________________________

Procedures can be used in SQL statements.

All of the following are purity level acronyms, except ____.

The main difference between functions and procedures is that a function is part of an expression.

Functions cannot be used in a(n) CHECK constraint or as a default value of a table column. _________________________

The RETURN statement can return constant values, such as a text string.

The term "actual parameters" refers to the parameters that are listed in the program unit.

A(n) procedure cannot be invoked in a standalone fashion. _________________________

The term "formal parameters" refers to the arguments that are used when calling or invoking the program unit.

A(n) ____ is a request a programmer includes within his or her code that asks Oracle to modify the default processing in some manner.

Which of the following statements is incorrect?

All of the following represent restrictions on functions, except ____.

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