Oracle Database Administration I — Question 65

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?

Answer options

• 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

Correct answer: B

Explanation

When DEFERRED_SEGMENT_CREATION is TRUE, segments are not created until data is inserted into the table. Since the CREATE TABLE command does not insert any data, no segments are created, making option B the correct choice. All other options incorrectly assume that segments will be created at the time of table creation.