Oracle
1Z0-082 · Question #38
1Z0-082 Question #38: Real Exam Question with Answer & Explanation
Sign in or unlock 1Z0-082 to reveal the answer and full explanation for question #38. The question stem and answer options stay visible for context.
Question
In the SALES database, DEFERRED_SEGMENT_CREATION is TRUE. Examine this command: SQL> CREATE TABLE T1(c1 INT PRIMARY KEY, c2 CLOB); Which segment or segments, if any, are created as a result of executing the command?
Options
- AT1, an index segment for the primary key, a LOB segment, and a lobindex segment
- Bno segments are created
- CT1 only
- DT1 and an index segment created for the primary key only
- ET1, an index segment for the primary key, and a LOB segment only
Unlock 1Z0-082 to see the answer
You've previewed enough free 1Z0-082 questions. Unlock 1Z0-082 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.