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 1520

You want to create a cursor that can be used several times in a block, selecting a different active set each time when it is opened. Which type of cursor do you create?

Option A

A.    a cursor for each active set
 

Option B

B.    a cursor FOR loop
 

Option C

C.    a cursor that uses parameters

 

Option D

D.    a multiple selection cursor

Correct Answer C
Explanation


Question ID 1521

The EMP table contains columns to hold the birth date and hire date of employees. Both of these columns are defined with DATE as their datatype. You want to insert a row with the details of
 
employee Smith who was born in 1944 and hired in 2004. Which statement will ensure that values are inserted into the table in the correct century?
 

Option A

A.    INSERT INTO EMP(empno, ename, birthdate, hiredate)
VALUES (EMPNO_SEQ.NEXTVAL,'SMITH', TO_DATE('12-DEC-44','DD-MON-YY'), TO_DATE('10-JUN-04','DD-MON-YY'));
 

Option B

B.    INSERT INTO EMP(empno, ename, birthdate, hiredate)
VALUES (EMPNO_SEQ.NEXTVAL,'SMITH', TO_DATE('12-DEC-1944','DD-MON-YYYY'), TO_DATE('10-JUN-04','DD-MON-RR'));
 

Option C

C.    INSERT INTO EMP(empno, ename, birthdate, hiredate) VALUES (EMPNO_SEQ.NEXTVAL,'SMITH',
TO_DATE('12-DEC-44','DD-MON-RR'),
 

Correct Answer B
Explanation

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