Name Null?

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?

A.
V_BLOB should be initialized to EMPTY_BLOB().

B.
The WRITE routine of DBMS_LOB should be used instead of LOADFROMFILE.

C.
The return type of DBMS_LOB.FILEEXISTS is not compatible with the IF statement.

D.
OPEN, CLOSE, and READONLY routines of DBMS_LOB should be used instead of
FILEOPEN, FILECLOSE, and FILE_READONLY.