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

What is a snapshot log?

i have procedure p1.and also i declare the same procedure in a package. whice one is efficient package procedure or procedure?

How to rename an index in oracle?

create one table to capture an employee details with a primary key.

what is the difference between restoring and recovering?

How do I start tns listener?

Why do we use coalesce function in oracle?

What are advantages of dateset in datastage?

How data locks are respected in oracle?

Does rowid change in oracle?

How to add another datafile to a tablespace?

what are indexes..how many types of index's are there and what are they?

For more Oracle General Interview Questions Click Here