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 1491

In the declarative section of a PL/SQL block, you created but did not initialize a number variable. When the block executes, what will be the initial value of the variable?

Option A

A.    The block will not execute because the variable was not initialized.The block will not execute because the variable was not initialized.
 

Option B

B.    0
 

Option C

C.    null

 

Option D

D.    It depends on the scale and precision of the variable.

Correct Answer C
Explanation


Question ID 1492

Examine the code:
DECLARE
CURSOR emp_cursor IS
SELECT ename, deptno
FROM emp;
emp_rec emp_cursor%ROWTYPE;
BEGIN
OPEN emp_cursor;
LOOP
FETCH emp_cursor
INTO emp_rec;
EXIT WHEN emp_cursor%NOTFOUND;
INSERT INTO temp_emp(name, dno)
VALUES (emp_rec.ename, emp_rec.deptno);
END LOOP;
CLOSE emp_cursor;
END;
Using a cursor FOR loop, which PL/SQL block is equivalent to the above code?
 

Option A

DECLARE
CURSOR emp_cursor IS
SELECT ename, deptno
FROM emp;
BEGIN
FOR emp_rec IN emp_cursor LOOP
INSERT INTO temp_emp(name, dno)
VALUES (emp_rec.ename, emp_rec.deptno);
END LOOP;
CLOSE emp_cursor;
END;
 

Option B

B.    DECLARE
CURSOR emp_cursor IS
SELECT ename, deptno
FROM emp;
BEGIN
FOR emp_rec IN emp_cursor LOOP
INSERT INTO temp_emp(name, dno)
VALUES (emp_rec.ename, emp_rec.deptno);
END LOOP;
END;
 

Option C

C.    DECLARE
CURSOR emp_cursor IS
SELECT ename, deptno
FROM emp;
emp_rec emp_cursor%ROWTYPE;
BEGIN
FETCH emp_cursor
INTO emp_rec;
FOR emp_rec IN emp_cursor LOOP
INSERT INTO temp_emp(name, dno)
VALUES (emp_rec.ename, emp_rec.deptno);
END LOOP;
END;
 

Option D

D.    DECLARE
CURSOR emp_cursor IS
SELECT ename, deptno
FROM emp;
BEGIN
FOR emp_rec IN emp_cursor LOOP
OPEN emp_cursor;
INSERT INTO temp_emp(name, dno)
VALUES (emp_rec.ename, emp_rec.deptno);
END LOOP;
END;
 

Correct Answer B
Explanation

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