What are the different type of Segments ?
Answers were Sorted based on User's Feedback
Answer / orawhiz
Data Segment,
Index Segment,
Rollback Segment and
Temporary Segment
| Is This Answer Correct ? | 6 Yes | 1 No |
Answer / nishi
4 types of segment
Index segment, data segment, temporary segment, rollback segment.
| Is This Answer Correct ? | 0 Yes | 0 No |
What is system tablespace?
Why required to run root.sh at the time of installation and what exactly it will do
What is an Oracle Instance?
Give the advantages and disadvantages of clusters.
what is the use of composite key constraint?
How to use an explicit cursor without open statements?
What are the oracle built-in data types?
what are archived logs?
What are the different types of failures that occur in Oracle database?
How to invoke the original export import utilities?
What is the use of file param in imp command?
What is a table index?