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 |
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 |
Option A | A. INSERT INTO EMP(empno, ename, birthdate, hiredate) |
Option B | B. INSERT INTO EMP(empno, ename, birthdate, hiredate) |
Option C | C. INSERT INTO EMP(empno, ename, birthdate, hiredate) VALUES (EMPNO_SEQ.NEXTVAL,'SMITH', |
Correct Answer | B |