Oracle Database Administration I — Question 111

Which three statements are true about Deferred Segment Creation in Oracle databases? (Choose three.)

Answer options

• A. It is supported for Index Organized Tables (IOTs) contained in locally managed tablespaces.
• B. It is the default behavior for tables and indexes.
• C. Sessions may dynamically switch back and forth from DEFERRED to IMMEDIATE segment creation.
• D. Indexes inherit the DEFERRED to IMMEDIATE segment creation attribute from their parent table
• E. It is supported for SYS-owned tables contained in locally managed tablespaces.

Correct answer: B, C, D

Explanation

The correct answer includes B, C, and D because B states that deferred segment creation is the default setting, C indicates that sessions can switch between segment creation modes, and D explains that indexes adopt this attribute from their tables. Options A and E are incorrect as they focus on specific cases rather than the general behavior of deferred segment creation.