Oracle Exam 1Z0-082 Topic 17 Question 80 Discussion

Actual exam question for Oracle's 1Z0-082 exam

Question #: 80
Topic #: 17

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?

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

Show Suggested Answer

Suggested Answer: B

by Rozella at Oct 06, 2023, 01:01 PM

Limited Time Offer

25%

Off

Contribute your Thoughts:

Submit Cancel

Currently there are no comments in this discussion, be the first to comment!