Oracle
1Z0-147 · Question #50
1Z0-147 Question #50: Real Exam Question with Answer & Explanation
Sign in or unlock 1Z0-147 to reveal the answer and full explanation for question #50. The question stem and answer options stay visible for context.
Question
Examine the declaration section:
DECLARE
CURSOR emp_cursor(p_deptno NUMBER, p_job VARCHAR2)
IS
SELECT empno, ename
FROM emp
WHERE deptno = p_deptno
AND job = p_job;
BEGIN
...
Which statement opens this cursor successfully?
Options
- AOPEN emp_cursor;
- BOPEN emp_cursor('Clerk', 10);
- COPEN emp_cursor(10,'Analyst');
- DOPEN emp_cursor(p_deptno, p_job);
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.