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 1493

You want to retrieve the employee details from the EMP table and process them in PL/SQL block. Which type of variable do you create in the PL/SQL block to retrieve all the rows and columns using a single SELECT statement from the EMP table?

Option A

A.    PL/SQL table of scalars
 

Option B

B.    PL/SQL table of records
 

Option C

C.    %ROWTYPE variable

 

Option D

D.    PL/SQL record

Correct Answer B
Explanation


Question ID 1494

Given this executable section of a PL/SQL block:
BEGIN
FOR employee_record IN salary_cursor LOOP
employee_id_table(employee_id) :=
employee_record.last_name;
END LOOP;
CLOSE salary_cursor;
END;
Why does this section cause an error?
 

Option A

A.    The cursor does not need to be closed.
 

Option B

B.    No FETCH statements were issued.

 

Option C

C.    Terminating conditions are missing.
 

Option D

D.    The cursor needs to be opened.

Correct Answer B
Explanation

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