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?

Question

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?

Accepted Answer

E. DROP FUNCTION gen_email_name;

Answer

A. DROP gen_email_name;

Answer

B. REMOVE gen_email_name;

Answer

C. DELETE gen_email_name;

Answer

D. TRUNCATE gen_email_name;

Answer

F. ALTER FUNCTION gen_email_name REMOVE;

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 :=…

Question

Options

How the community answered

Community Discussion