試題詳解

QUESTION 50 Examine this code: CREATE OR REPLACE STORED FUNCTION get_sal (p_raise_amt NUMBER, p_employee_id employees.employee_id%TYPE) RETURN NUMBER IS v_salaryNUMBER; v_raise NUMBER(8,2); BEGIN SELECT salary INTO v_salary FROM employees WHERE 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.