問題詳情

QUESTION 37Examine this code:CREATE OR REPLACE FUNCTION gen_email_name(p_first_name VARCHAR2, p_last_name VARCHAR2, p_id NUMBER) RETURN VARCHAR2ISv_email_name VARCHAR2(19=;BEGINv_email_name := SUBSTR(p_first_name, 1, 1) ||SUBSTR(p_last_name, 1, 7) ||'@Oracle.com';UPDATE employeesSET email = v_email_nameWHERE 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;

參考答案

答案:E
難度:非常困難0
統計:A(0),B(0),C(1),D(0),E(0)