Which two statements are true?

The DEFERRED_SEGMENT_CREATION parameter is set to TRUE in your database instance.
You execute the following command to create a table:

Which two statements are true?

The DEFERRED_SEGMENT_CREATION parameter is set to TRUE in your database instance.
You execute the following command to create a table:

Which two statements are true?

A.
The table is created without a segment because the storage clause is missing.

B.
A segment is allocated when the first row is inserted in the table.

C.
A segment is allocated when an index is created for any column in the table.

D.
The table is created and extents are immediately allocated as per the default storage defined for its
tablespace.

E.
A segment is allocated for the table if the ALTER TABLEā€¦ ALLOCATE EXTENT command is issued.



Leave a Reply 0

Your email address will not be published. Required fields are marked *