What are the different type of Segments ?

Answer Posted / nishi

4 types of segment

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

Is This Answer Correct ?    0 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Explain the use of consistent option in exp command.

550


What is the difference between alert log file and tarce file ?

1634


What is a table index in oracle?

632


What is sequence?

624


Where do you use decode and case statements?

554






How do I learn what codesets are available in oracle?

575


What are the execution control statements?

619


how do we code triggers , store procedure , Performance tuning and indexing in a Java Project? Pls kindly get me the perfect answer with the code for each....thank you in advance............pls any body kindly help me soon as possible....

1587


Can group functions be used in the order by clause in oracle?

580


What is data type in oracle?

560


What are the various oracle database objects?

676


How do I manually create a database in oracle?

546


Is it possible to insert comments into sql statements return in the data model editor ?

2063


What is a package ? What are the advantages of package ?

603


Explain the use of show option in imp command.

638