Match the following definition to the terms or concepts:
Function
A subprogram that returns a value. Answer 1
Procedure
It is a subprogram that does not return a value to the caller. Answer 2
Trigger
It is automatically fired in response to a specified event. Answer 3
Feedback
Your answer is correct.
Correct
Marks for this submission: 3.00/3.00.
Question 2
Correct
Mark 1.00 out of 1.00
Flag question
Question text
CREATE OR REPLACE PROCEDURE dept_salary
(v_bonus IN BOOLEAN, v_raise IN BOOLEAN, v_issue_check IN OUT BOOLEAN) IS
BEGIN
v_issue_check := v_bonus OR v_raise;
END;
If v_bonus = TRUE and v_raise = NULL, which is assigned to v_raise_check?
Select one:
A. NONE
B. FALSE
C. NULL
D. TRUE
Feedback
This study source was downloaded by 100000899606070 from CourseHero.com on 02-23-2026 22:21:43 GMT -06:00
https://www.coursehero.com/file/87110538/QUIZdocx/
, Your answer is correct.
Correct
Marks for this submission: 1.00/1.00.
Question 3
Correct
Mark 0.67 out of 1.00
Flag question
Question text
If v_energy_line equals TRUE, and v_proper_ratio equals NULL, which value is assigned to ret_val?
CREATE OR REPLACE FUNCTION found_isotope (v_energy_line IN BOOLEAN, v_proper_ratio IN
BOOLEAN) RETURN NUMBER IS ret_val NUMBER;
BEGIN
IF(v_energy_line AND v_proper_ratio) THEN ret_val:=1;
ELSIF NOT (v_energy_line ANDv_proper_ratio) THEN ret_val:=2;
ELSIF (v_energy_line AND v_proper_ratio) IS NULL THENret_val:= -1;
END IF;
RETURN ret_val;
END;
Select one:
A. 2
B. 1
C. NULL
D. -1
Feedback
Your answer is correct.
Correct
Marks for this submission: 1.00/1.00. Accounting for previous tries, this gives 0.67/1.00.
Question 4
Correct
Mark 1.00 out of 1.00
This study source was downloaded by 100000899606070 from CourseHero.com on 02-23-2026 22:21:43 GMT -06:00
https://www.coursehero.com/file/87110538/QUIZdocx/
Function
A subprogram that returns a value. Answer 1
Procedure
It is a subprogram that does not return a value to the caller. Answer 2
Trigger
It is automatically fired in response to a specified event. Answer 3
Feedback
Your answer is correct.
Correct
Marks for this submission: 3.00/3.00.
Question 2
Correct
Mark 1.00 out of 1.00
Flag question
Question text
CREATE OR REPLACE PROCEDURE dept_salary
(v_bonus IN BOOLEAN, v_raise IN BOOLEAN, v_issue_check IN OUT BOOLEAN) IS
BEGIN
v_issue_check := v_bonus OR v_raise;
END;
If v_bonus = TRUE and v_raise = NULL, which is assigned to v_raise_check?
Select one:
A. NONE
B. FALSE
C. NULL
D. TRUE
Feedback
This study source was downloaded by 100000899606070 from CourseHero.com on 02-23-2026 22:21:43 GMT -06:00
https://www.coursehero.com/file/87110538/QUIZdocx/
, Your answer is correct.
Correct
Marks for this submission: 1.00/1.00.
Question 3
Correct
Mark 0.67 out of 1.00
Flag question
Question text
If v_energy_line equals TRUE, and v_proper_ratio equals NULL, which value is assigned to ret_val?
CREATE OR REPLACE FUNCTION found_isotope (v_energy_line IN BOOLEAN, v_proper_ratio IN
BOOLEAN) RETURN NUMBER IS ret_val NUMBER;
BEGIN
IF(v_energy_line AND v_proper_ratio) THEN ret_val:=1;
ELSIF NOT (v_energy_line ANDv_proper_ratio) THEN ret_val:=2;
ELSIF (v_energy_line AND v_proper_ratio) IS NULL THENret_val:= -1;
END IF;
RETURN ret_val;
END;
Select one:
A. 2
B. 1
C. NULL
D. -1
Feedback
Your answer is correct.
Correct
Marks for this submission: 1.00/1.00. Accounting for previous tries, this gives 0.67/1.00.
Question 4
Correct
Mark 1.00 out of 1.00
This study source was downloaded by 100000899606070 from CourseHero.com on 02-23-2026 22:21:43 GMT -06:00
https://www.coursehero.com/file/87110538/QUIZdocx/
