Oracle
1Z0-147 · Question #46
1Z0-147 Question #46: Real Exam Question with Answer & Explanation
Sign in or unlock 1Z0-147 to reveal the answer and full explanation for question #46. The question stem and answer options stay visible for context.
Question
Examine this code:
CREATE OR REPLACE PROCEDURE add_dept
(p_dept_name VARCHAR2 DEFAULT 'placeholder',
p_location VARCHAR2 DEFAULT 'Boston')
IS
BEGIN
INSERT INTO departments
VALUES (dept_id_seq.NEXTVAL, p_dept_name, p_location);
END add_dept;
/
Which three are valid calls to the add_dept procedure ? (Choose three.)
Options
- Aadd_dept;
- Badd_dept('Accounting');
- Cadd_dept(', 'New York');
- Dadd_dept(p_location=>>'New York');
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.