Which statement is true about the execution of the code?

Examine the following PL/SQL code:

The server output is on for the session. Which statement is true about the execution of the code?

Examine the following PL/SQL code:

The server output is on for the session. Which statement is true about the execution of the code?

A.
The code executes successfully and gives the desired output.

B.
The code generates an error because the EMP_RECORD variable is not declared.

C.
The code generates an error because the cursor is not opened before the FOR loop.

D.
The code generates an error because the loop does not have the exit when clause.

Show Hint

← Previous question

Next question →

Leave a Reply 15

Vipin

Hello every one,

if anyone has given 1z0-144 exam, please tell me if all the 78 questions given here is enough to pass the exam.
Pls reply.

Thanks.

Devendra

Even I want to know the answer of the comment from Vipin. Anyone please reply ??????

Raghav

Even I would like to know ……?

Justyna

Can happen that you will have only these questions, but is also possible that you get a few different questions. You never know. usualy you need about 60-70% perecent to pass exam. It depends on the exam (PL/SQl, or SQL, database administration etc.)

It could be nice to have the code snippet in this one.

Sandor

DECLARE
CURSOR C_EMP_CURSOR IS
SELECT EMPLOYEE_ID, LAST_NAME FROM EMPLOYEES
WHERE DEPARTMENT_ID = 30;
BEGIN
FOR EMP_RECORD IN C_EMP_CURSOR
LOOP
DBMS_OUTPUT.PUT_LINE(EMP_RECORD.EMPLOYEE_ID||’ ‘||EMP_RECORD.LAST_NAME);
END LOOP;
END;
/