Oracle
1Z0-072 · Question #18
1Z0-072 Question #18: Real Exam Question with Answer & Explanation
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
Community Discussion
No community discussion yet for this question.