Oracle
1Z0-146 · Question #79
1Z0-146 Question #79: Real Exam Question with Answer & Explanation
Sign in or unlock 1Z0-146 to reveal the answer and full explanation for question #79. The question stem and answer options stay visible for context.
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.
Unlock 1Z0-146 to see the answer
You've previewed enough free 1Z0-146 questions. Unlock 1Z0-146 for full answers, explanations, the timed quiz mode, progress tracking, and the master PDF. Question stem and options stay visible so you can still see what's on the exam.