Oracle
1Z0-147 · Question #46
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…
The correct answer is A. add_dept; B. add_dept('Accounting'); D. add_dept(p_location=>>'New York'). See the full explanation below for the reasoning.
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');
How the community answered
(35 responses)- A74% (26)
- C26% (9)
Community Discussion
No community discussion yet for this question.