READ Free Dumps For Oracle- 1z0-146

Question ID 2809	View Exhibit1 and examine the structure of the EMPLOYEES table.   View the Exhibit2 and examine the PL/SQL block that you execute for displaying the last name and hire date of the employees in department ID 60. Which statement is true about the outcome?
Option A	A.    It generates an error because RECORD type cannot be used with varrays.
Option B	B.    It generates an error because BULK COLLECT cannot be used with varrays.
Option C	C.    It executes successfully only if department ID 60 has five or less than five employees.
Option D	D.    It executes successfully even if department ID 60 has more than five employees by dynamically extending the varray.
Correct Answer	C

Explanation

Question ID 2810	Which two guidelines should be considered when designing and using cursors in a PL/SQL block? (Choose two.)
Option A	A.    When fetching from a cursor, fetch into a record.
Option B	B.    When fetching from a cursor, fetch required values into individually declared variables.
Option C	C.    Whenever possible, explicitly declare the cursor and use the OPEN, FETCH, and CLOSE statements to manipulate the cursor instead of using the cursor FOR loop.
Option D	D. Whenever possible, use the cursor FOR loop instead of explicitly declaring the cursor and using the OPEN, FETCH, and CLOSE statements to manipulate the cursor.
Correct Answer	A,D

Explanation

Previous-Page 1 2. . . 36 37 38 39 40 41 42. . . 93 94 Next-Page

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