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 1495

Evaluate this PL/SQL block:
DECLARE
v_result NUMBER(2);
BEGIN
DELETE
FROM employee
WHERE dept_id IN (10, 20, 30);
v_result := SQL%ROWCOUNT;
COMMIT;
END;
What will be the value of V_RESULT if no rows are deleted?
 

Option A

A.    1
 

Option B

B.    NULL
 

Option C

C.    0
 

Option D

D.    FALSE
 

Correct Answer C
Explanation


Question ID 1496

Which SELECT statement displays all the employees who do not have any subordinates?

Option A

A.    SELECT e.ename
FROM emp e
WHERE e.empno NOT IN (SELECT m.mgr
FROM emp m
WHERE m.mgr IS NOT NULL);
 

Option B

B.    SELECT e.ename
FROM emp e
WHERE e.empno IN (SELECT m.mgr
FROM emp m);
 

Option C

C.    SELECT e.ename
FROM emp e
WHERE e.mgr IS NOT NULL;
 

Option D

D.    SELECT e.ename
FROM emp e
WHERE e.empno NOT IN (SELECT m.mgr
FROM emp m);
 

Correct Answer A
Explanation

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