When will be a segment released?

Question Posted / guest

When will be a segment released?..

Answer / orawhiz

When Segment is dropped.
When Shrink (RBS only)
When truncated (TRUNCATE used with drop storage option)

Is This Answer Correct ?

2 Yes

0 No

More Oracle Architecture Interview Questions

What is the role of PCTFREE parameter is Storage clause ?

List the factors that can affect the accuracy of the estimations ?

How will you create multiple rollback segments in a database ?

How the space utilisation takes place within rollback segments?

When Does DBWR write to the database?

Which parameter in Storage clause will reduce no. of rows per block?

How will you estimate the space required by a non-clustered tables?

List the Optional Flexible Architecture (OFA) of Oracle database ?

What is Server Process?

What is the maximum size of a row in oracle 9i?

What is Shared Pool?

Name the ORACLE Background Process?

For more Oracle Architecture Interview Questions Click Here