Oracle
1Z0-082 · Question #38
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…
The correct answer is C. T1 only. See the full explanation below for the reasoning.
Manage Storage
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
How the community answered
(36 responses)- A8% (3)
- B3% (1)
- C81% (29)
- D3% (1)
- E6% (2)
Topics
#deferred segment creation#LOB segments#CLOB#primary key index
Community Discussion
No community discussion yet for this question.