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 blob datatype?
How to import one table back from a dump file?
How to find the date and time of last updated table?
How will you write a query to get a 5th rank student from a table student_report?
Can you drop an index associated with a unique or primary key constraint?
what are the different types of cursors? explain?
Can select statements be used on views in oracle?
Explain what are the different type of segments?
how to use select statement as formal parameter in procedure specification?(someone said that using string) ex:-procedure(a in number,select ename from emp ) i am asking syntax like this?
difference between truncate and delete ,drop?
How to use in conditions in oracle?
What language does oracle use?