Which three statements are true about Deferred Segment Creation in Oracle databases?
A.It is the default behavior for tables and indexes. B.It is supported for sys-owned tables contained in locally managed tablespaces C.Sessions may dynamically switch back and forth from DEFERRED to IMMEDIATE segment正确答案ACD
Creation. D.Indexes inherit the DEFERRED or IMMEDIATE segment creation attribute from their parent
Table E.It is supported for Index Organized Tables(IOTs) contained in locally managed tablespaces.
