Which three statements are true about Deferred Segment Creation in Oracle databases?
It Is supported for Index Organized Tables (IOTs) contained in locally managed tablespaces.
Sessions may dynamically switch back and forth from deferred to immediate segment creation.
It Is the default behavior for tables and indexes.
It is supported for SYS-owned tables contained in locally managed tablespaces.
Indexes inherit the deferred or immediate segment creation attribute from their parent table
Submit