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?
Sign in or unlock 1Z0-072 to reveal the answer and full explanation for question #18. The question stem and answer options stay visible for context.
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
Unlock 1Z0-072 to see the answer
You've previewed enough free 1Z0-072 questions. Unlock 1Z0-072 for full answers, explanations, the timed quiz mode, progress tracking, and the master PDF. Question stem and options stay visible so you can still see what's on the exam.