Oracle
1Z0-146 · Question #19
1Z0-146 Question #19: Real Exam Question with Answer & Explanation
Sign in or unlock 1Z0-146 to reveal the answer and full explanation for question #19. The question stem and answer options stay visible for context.
Question
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?
Exhibit
Options
- AThe L_OUT variable must be initialized to an empty locator.
- BThe L_OUT variable has to be declared as a temporary LOB.
- CThe A_CLOB variable has to be declared as a temporary LOB.
- DThe clause RETURNING col2 INTO a_clob should be added to the INSERT statement to correctly
Unlock 1Z0-146 to see the answer
You've previewed enough free 1Z0-146 questions. Unlock 1Z0-146 for full answers, explanations, the timed quiz mode, progress tracking, and the master PDF. Question stem and options stay visible so you can still see what's on the exam.