What are the different type of Segments ?

Question Posted / guest

Answers were Sorted based on User's Feedback

What are the different type of Segments ?..

Answer / orawhiz

Data Segment,
Index Segment,
Rollback Segment and
Temporary Segment

Is This Answer Correct ?

6 Yes

1 No

What are the different type of Segments ?..

Answer / nishi

4 types of segment

Index segment, data segment, temporary segment, rollback segment.

Is This Answer Correct ?

0 Yes

0 No

More Oracle General Interview Questions

How would you best determine why your MVIEW couldnt FAST REFRESH?

What do you mean by merge in oracle and how can we merge two tables?

How to convert characters to times in oracle?

Write query to fetch second maximum salary from employee table.

How data locks are respected in oracle?

How to use "in" parameter properly?

What is hash cluster in oracle?

difference between imlicit cursor and explicit cursor ?

Is postgres faster than oracle?

What are the attributes that are found in a cursor?

How to insert a new row into a table in oracle?

how to join query for one source type is oracle another source type is sql server ?

For more Oracle General Interview Questions Click Here