Q62 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?
- (A). T1, an index segment for the primary key, a LOB segment, and a lobindex segment
- (B). no segments are created
- (C). T1 only
- (D). T1 and an index segment created for the primary key only
- (E). T1, an index segment for the primary key, and a LOB segment only
Answer: B