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 the log writer writes the data into database

What is Shared SQL Area?

What is the function of Redo Log in Oracle?

THE MAIN CONCEPT OF PROGRAMMIN TYPE?

When Does DBWR write to the database?

What do Redo Log Buffers contain?

What is Database Buffers ?

What are the components of SGA?

What is the significance of having storage clause ?

• What is oracle Architecture?

How can you find the size of a database?

How to define Data Block size in Oracle?

For more Oracle Architecture Interview Questions Click Here