Oracle Database 23ai Administration Associate 1z0-182 Question # 10 Topic 2 Discussion

Oracle Database 23ai Administration Associate 1z0-182 Question # 10 Topic 2 Discussion

1z0-182 Exam Topic 2 Question 10 Discussion:
Question #: 10
Topic #: 2

Which three statements are true about Deferred Segment Creation in Oracle databases?


A.

It is supported for Index Organized Tables (IOTs) contained in locally managed tablespaces.


B.

It is supported for SYS-owned tables contained in locally managed tablespaces.


C.

It is the default behavior for tables and indexes.


D.

Indexes inherit the DEFERRED or IMMEDIATE segment creation attribute from their parent table.


E.

Sessions may dynamically switch back and forth from DEFERRED to IMMEDIATE segment creation.


Get Premium 1z0-182 Questions

Contribute your Thoughts:


Chosen Answer:
This is a voting comment (?). It is better to Upvote an existing comment if you don't have anything to add.