Which of the following correctly creates a function that performs an update on the BB_TEST1 table?
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

Quizplus · Accepted Answer

Choice A correctly creates a function that takes in a number parameter and performs an update on the BB_TEST1 table, setting the value of col1 to the input parameter. It also returns the input parameter. Choice B has a syntax error with a semicolon after the UPDATE statement, and does not specify which column to update. Choice C does not have a data type specified for the input parameter and does not include an UPDATE statement. Choice D has a data type specified for the input parameter but is overly specific indicating a 6 digit limit that may not be necessary. It also has a missing semicolon at the end of the RETURN statement.

Which of the Following Correctly Creates a Function That Performs