Oracle
1Z0-146 · Question #79
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…
The correct answer is A. The table is created successfully. See the full explanation below for the reasoning.
Question
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?
Options
- AThe table is created successfully.
- BIt generates an error because DEFAULT cannot be set to EMPTY_BLOB() during table creation.
- CIt generates an error because DEFAULT cannot be set to null for a CLOB column during table creation.
- DIt generates an error because DEFAULT cannot be set to null for a BFILE column during table creation.
How the community answered
(46 responses)- A85% (39)
- B9% (4)
- C2% (1)
- D4% (2)
Community Discussion
No community discussion yet for this question.