試題詳解

QUESTION 37 Examine this code: CREATE OR REPLACE FUNCTION gen_email_name (p_first_name VARCHAR2, p_last_name VARCHAR2, p_id NUMBER) RETURN VARCHAR2 IS v_email_name VARCHAR2(19=; BEGIN v_email_name := SUBSTR(p_first_name, 1, 1) || SUBSTR(p_last_name, 1, 7) || '@Oracle.com'; UPDATE employees SET email = v_email_name WHERE employee_id = p_id; RETURN v_email_name; END; Which statement removes the function?
(A) DROP gen_email_name;
(B) REMOVE gen_email_name;
(C) DELETE gen_email_name;
(D) TRUNCATE gen_email_name;
(E) DROP FUNCTION gen_email_name; (AB).ALTER FUNCTION gen_email_name REMOVE;