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

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

How to find the current session sid

how oracle will recognise its space is 100gb if 100gb is allocated for it...

How will you monitor the space allocation ?

What is the function of Dispatcher (Dnnn)?

How to calculate the approximate size of the SGA based on the size of the block,shared_pool,redo_buffer_cache and db_buffer_cache?

How will you swap objects into a different table space for an existing database?

What is the maximum number of Lock Processes used?

What is an Oracle Data Dictionary?

What is an oracle database schema?

• What is oracle Architecture?

What is an Integrity Constrains in Oracle?

For more Oracle Architecture Interview Questions Click Here