ExamQuestions.com

Register
Login
Oracle Database 11g Advanced PLSQL Exam Questions

Oracle

Oracle Database 11g Advanced PLSQL

18 / 68

Question 18:

See the Exhibit: 
image
DATA_FILES is a directory object that contains the DETAILS.txt text file. You have the required permissions to access the directory object. You have a table using the following command: CREATE TABLE clob_tab(col2,CLOB); Examine the PL/SQL statement in exhibit 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? 

Answer options:

A. The L_OUT variable must be initialized to an empty locator
B. The L_OUT variable has to be declared as a temporary LOB
C. The A_CLOB variable has to be declared as a temporary LOB
D. The clause RETURINING col2 INTO a a_clob should be added to the INSERT statement to correctly initialize the locator