QUESTION 50Examine this code:CREATE OR REPLACE STORED FUNCTION get_sal(p_raise_amt NUMBER, p_employee_idemployees.employee_id%TYPE)RETURN NUMBERISv_salaryNUMBER;v_raise NUMBER(8,2);BEGINSELECT salaryINTO v_salaryFROM employeesWHERE employee_id = p_employee_id;v_raise := p_raise_amt * v_salary;RETURN v_raise;END;Which statement is true?short
(A)This statement creates a stored procedure named get_sal.
(B)This statement returns a raise amount based on an employee id.
(C)This statement creates a stored function named get_sal with a status of invalid.
(D)This statement creates a stored function named get_sal.
(E)This statement fails.