Oracle
1Z0-146 · Question #63
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…
The correct answer is C. The return type of DBMS_LOB.FILEEXISTS is not compatible with the IF statement. See the full explanation below for the reasoning.
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,
How the community answered
(27 responses)- A7% (2)
- B4% (1)
- C85% (23)
- D4% (1)
Community Discussion
No community discussion yet for this question.