Free 1Z0-148 Web TestEngine Demo

Q27 Single choice

Examine the structure of the EMP table:

Name
Null? Type
------ ----- -------
EMPNO NOT NULL NUMBER (4)
ENAME
VARCHAR2 (10) SAL NUMBER (7, 2)

Examine this code:

Which code should be inserted to display the collection contents?

A
1_indx := 1_list.FIRST;
WHILE (1_indx IS NOT NULL) LOOP
DBMS_OUTPUT.PUT_LINE (1_indx || ' ' || 1_list (1_indx));
1_indx := 1_emp.NEXT (1_indx);
END LOOP;
B
FOR indx IN 1_list. COUNT .. -1 LOOP
DBMS_OUTPUT.PUT_LINE (indx | | ' ' | | 1_list (indx));
END LOOP;
C
FOR indx IN -1 .. 1_list.LIMIT LOOP
DBMS_OUTPUT.PUT_LINE (indx | | ' ' | | 1_list (indx) );
END LOOP;
D
FOR indx IN 1_list.FIRST . . 1_list.LAST LOOP
DBMS_OUTPUT.PUT_LINE (indx | | ' ' | | 1_list (indx));
END LOOP;

1Z0-148 Web TestEngine demo