Oracle
1Z0-147 · Question #17
1Z0-147 Question #17: Real Exam Question with Answer & Explanation
Sign in or unlock 1Z0-147 to reveal the answer and full explanation for question #17. The question stem and answer options stay visible for context.
Question
Examine this code:
CREATE OR REPLACE FUNCTION calc_sal
(p_salary NUMBER)
RETURN NUMBER
IS
v_raise NUMBER(4,2) DEFAULT 1.08;
BEGIN
RETURN v_raise * p_salary;
END calc_sal;
/
Which statements accurately call the stored function CALC_SAL ? (Choose two.)
Options
- AUPDATE employees (calc_sal(salary)) SET salary = salary * calc_sal(salary);
- BINSERT calc_sal(salary) INTO employees WHERE department_id = 60;
- CDELETE FROM employees(calc_sal(salary)) WHERE calc_sal(salary) > 1000;
- DSELECT salary, calc_sal(salary) FROM employees WHERE department_id = 60;
- ESELECT last_name, salary, calc_sal(salary) FROM employees ORDER BY calc_sal(salary);
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.