Oracle
1Z0-147 · Question #23
1Z0-147 Question #23: Real Exam Question with Answer & Explanation
Sign in or unlock 1Z0-147 to reveal the answer and full explanation for question #23. The question stem and answer options stay visible for context.
Question
Examine this code:
CREATE OR REPLACE STORED FUNCTION get_sal
(p_raise_amt NUMBER, p_employee_id employees.employee_id%TYPE)
RETURN NUMBER
IS
v_salary NUMBER;
v_raise NUMBER(8,2) ;
BEGIN
SELECT salary
INTO v_salary
FROM employees
WHERE employee_id = p_employee_id;
v_raise := p_raise_amt + v_salary;
RETURN v_raise;
END;
/
Which statement is true?
Options
- AThis statement creates a stored procedure named get_sal.
- BThis statement returns a raise amount based on an employee id.
- CThis statement creates a stored function named get_sal with a status of invalid.
- DThis statement creates a stored function named get_sal.
- EThis statement fails.
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.