Oracle
1Z0-147 · Question #50
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…
The correct answer is C. OPEN emp_cursor(10,'Analyst'). See the full explanation below for the reasoning.
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);
How the community answered
(20 responses)- A10% (2)
- B5% (1)
- C70% (14)
- D15% (3)
Community Discussion
No community discussion yet for this question.