You issue this command to create a table called LOB_STORE:
CREATE TABLE lob_store
(lob_id NUMBER(3),
photo BLOB DEFAULT EMPTY_BLOB(),
cv CLOB DEFAULT NULL,
ext_file BFILE DEFAULT NULL)
/
What is the outcome?
A.
The table is created successfully.
B.
It generates an error because DEFAULT cannot be set to EMPTY_BLOB() during table
creation.
C.
It generates an error because DEFAULT cannot be set to null for a CLOB column during table
creation.
D.
It generates an error because DEFAULT cannot be set to null for a BFILE column during table
creation.
A