AllExam Dumps

DUMPS, FREE DUMPS, VCP5 DUMPS| VMWARE DUMPS, VCP DUMPS, VCP4 DUMPS, VCAP DUMPS, VCDX DUMPS, CISCO DUMPS, CCNA, CCNA DUMPS, CCNP DUMPS, CCIE DUMPS, ITIL, EXIN DUMPS,


READ Free Dumps For Oracle- 1z0-001





Question ID 1575

In which section of a PL/SQL block is a user-defined exception raised?

Option A

A.    heading
 

Option B

B.    declarative
 

Option C

C.    executable
 

Option D

D.    exception handling
 

Correct Answer C
Explanation


Question ID 1576

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?
 

Option A

A.    OPEN emp_cursor('Clerk', 10);
 

Option B

B.    OPEN emp_cursor;
 

Option C

C.    OPEN emp_cursor(p_deptno, p_job);

 

Option D

D.    OPEN emp_cursor(10,'Analyst');

Correct Answer D
Explanation

Send email to admin@getfreedumps for new dumps request!!!