Oracle
1Z0-146 · Question #63
1Z0-146 Question #63: Real Exam Question with Answer & Explanation
Sign in or unlock 1Z0-146 to reveal the answer and full explanation for question #63. The question stem and answer options stay visible for context.
Question
Examine the structure of the LOB_STORE table. Name Null? Type ----------- ------ ------------ LOB_ID NUMBER VIDEO_CLIP BLOB You create a 'DATA_FILES' directory object that contains the 'IMAGE1.GIF'operating system (OS) file. View the Exhibit and examine the LOAD_LOB procedure code that you execute for reading data from the OS file into the BLOB column. It is created with compilation errors. What is the reason?
Exhibit
Options
- AV_BLOB should be initialized to EMPTY_BLOB().
- BThe WRITE routine of DBMS_LOB should be used instead of LOADFROMFILE.
- CThe return type of DBMS_LOB.FILEEXISTS is not compatible with the IF statement.
- DOPEN, CLOSE, and READONLY routines of DBMS_LOB should be used instead of FILEOPEN,
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.