What is the outcome?

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?

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.



Leave a Reply 1

Your email address will not be published. Required fields are marked *