Which of the Following Correctly Creates a Function That Performs

Multiple Choice

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