QUESTION 80Which code successfully calculates tax?
(A)CREATE OR REPLACE PROCEDURE calctax (p_no IN NUMBER) RETURN tax ISv_sal NUMBER;tax Number;BEGINSELECT sal INTO v_salFROM empWHERE empno = p_no;tax := v_sal * 0.05;END;
(B)CREATE OR REPLACE FUNCTION calctax (p_no NUMBER)RETURN NUMBER ISv_sal NUMBERBEGINSELECT sal INTO v_salFROM empWHERE empno = p_no;RETURN:= v_sal * 0.05;end
(C)CREATE OR REPLACE FUNCTION calctax (p_no NUMBER)RETURN NUMBER ISv_sal NUMBER;tax NUMBER;BEGINSELECT sal INTO v_salFROM empWHERE empno = p_no;tax := v_sal * 0.05;END
(D)CREATE OR REPLACE FUNCTION calctax (p_no NUMBER) IS v_sal NUMBER;tax NUMBER;BEGINSELECT sal INTO v_salFROM empWHERE empno = p_no;tax := v_sal * 0.05;return (tax);END;