Oracle
1Z0-072 · Question #18
In the ORCL database, DEFERRED_SEGMENT_CREATION is FALSE. Examine this command: SQL> CREATE TABLE t1(c1 INT PRIMARY KEY, C2 CLOB); Which table segments are created?
The correct answer is D. T1, an index segment for the primary key, and a LOB segment only. See the full explanation below for the reasoning.
Question
In the ORCL database, DEFERRED_SEGMENT_CREATION is FALSE.
Examine this command:
SQL> CREATE TABLE t1(c1 INT PRIMARY KEY, C2 CLOB);
Which table segments are created?
Options
- AT1 and an index segment for the primary key only
- BT1, an index segment for the primary key, a LOB segment, and lobindex segment
- CT1 only
- DT1, an index segment for the primary key, and a LOB segment only
How the community answered
(24 responses)- A4% (1)
- B17% (4)
- C4% (1)
- D75% (18)
Community Discussion
No community discussion yet for this question.