Oracle
1Z0-147 · Question #7
1Z0-147 Question #7: Real Exam Question with Answer & Explanation
Sign in or unlock 1Z0-147 to reveal the answer and full explanation for question #7. The question stem and answer options stay visible for context.
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?
Options
- ADROP gen_email_name;
- BREMOVE gen_email_name;
- CDELETE gen_email_name;
- DTRUNCATE gen_email_name;
- EDROP FUNCTION gen_email_name;
- FALTER FUNCTION gen_email_name REMOVE;
Unlock 1Z0-147 to see the answer
You've previewed enough free 1Z0-147 questions. Unlock 1Z0-147 for full answers, explanations, the timed quiz mode, progress tracking, and the master PDF. Question stem and options stay visible so you can still see what's on the exam.