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 2787

You created a PL/SQL subprogram that successfully invokes an external C procedure. After a while, the database administrator (DBA) drops the alias library schema object. The shared library exists in the system. Which statement is true in this scenario?
 

Option A

A.    The corresponding shared library is also removed from the system.
 

Option B

B.    PL/SQL subprograms can be used to invoke the external C procedure.
 

Option C

C.    The existing extproc process is terminated and a new extproc is started.
 

Option D

D.    The PL/SQL subprogram that depends on the external C program becomes invalid.
 

Correct Answer D
Explanation


Question ID 2788

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 clob should be added to the INSERT statement to correctly initialize the locator. 

Correct Answer D
Explanation

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