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 2743

DATA_FILES is a directory object that contains the DETAILS.TXT text file. You have the required permissions to access the directory object.
 
You create a table using the following command:
CREATE TABLE clob_tab(col2 CLOB);
View the Exhibit and examine the PL/SQL block that you execute for loading the external text file
into the table that currently has no rows. The PL/SQL block results in an error.
What correction must be done to ensure the PL/SQL block executes successfully?

Option A

A.    The L_OUT variable must be initialized to an empty locator.

Option B

B.    The L_OUT variable has to be declared as a temporary LOB.

Option C

C.    The A_CLOB variable has to be declared as a temporary LOB.

Option D

D.    The clause RETURNING col2 INTO aclob should be added to the INSERT statement to correctly initialize the locator

Correct Answer D
Explanation


Question ID 2744

Which two statements are true about associative arrays and varrays? (Choose two.)

Option A

A.    Only varrays must start with the subscript 1.
 

Option B

B.    Only varrays can be used as column types in database tables.
 

Option C

C.    Both associative arrays and varrays must start with the subscript 1.
 

Option D

D.    Both associative arrays and varrays can be used as column types in database tables.
 

Correct Answer A,B
Explanation

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