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-146





Question ID 2843

View the Exhibit and examine the structure of the EMPLOYEES table.


Examine the following PL/SQL block for storing the salary of all sales representatives from the EMPLOYEES table in an associative array:
1 DECLARE
2 emp_cv SYS_REFCURSOR;
3 TYPE list IS TABLE OF emp_cv;
4 sals list;
5 BEGIN
6 OPEN emp_cv FOR SELECT salary FROM employees
7 WHERE job_id = 'SA_REP';
8 FETCH emp_cv BULK COLLECT INTO sals;
9 CLOSE emp_cv;
10 END;
What should you correct in the above code to ensure that it executes successfully?

Option A

A.    Replace EMP_CV in line 3 with employees.salary%TYPE.
 

Option B

B.    Replace line 2 with TYPE refcur IS REF CURSOR; emp_cv refcur;.
 

Option C

C.    Replace BULK COLLECT in line 8 with the OPEN, FETCH, LOOP, and CLOSE statements.
 

Option D

D.    Replace line 2 with TYPE refcur IS REF CURSOR RETURN employees.salary%TYPE; emp_cv refcur;.

Correct Answer A
Explanation


Question ID 2844

Which two statements are true about the DBMS_LOB.CREATETEMPORARY procedure that is used to create a temporary LOB? (Choose two.)
 

Option A

A.    It can be used for transforming data in permanent internal LOBs.
 

Option B

B.    It is used only for the migration of BasicFile to the SecureFile format.
 

Option C

C.    It is used only for the migration of the LONG column to the LOB column.
 

Option D

D.    It creates a LOB variable that is not associated with any table and is stored in the user's temporary tablespace.
 

Option E

E.    It creates a LOB variable that is associated with a specific table and is temporarily stored in the user's default tablespace.
 

Correct Answer A,D
Explanation

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