What are the different type of Segments ?

Answer Posted / orawhiz

Data Segment,
Index Segment,
Rollback Segment and
Temporary Segment

Is This Answer Correct ?    6 Yes 1 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Is there a combination of "like" and "in" in sql?

575


Explain the difference between replace() and translate() functions in oracle?

573


How to execute a stored program unit?

578


In AP we done Customizations for Late Payments Charges. For Reporting Purpose What are the Documents Prepared for Customer Understanding??

1201


Which dictionary view(s) would you first look at to understand or get a high-level idea of a given Advanced Replication environment?

1477






What is the difference between post-database commit and post-form commit?

511


1) WIll all the user get the DEFAULT profile, if their current profile got deleted at any point of time? 2) What are the Situation we need to MOVE the TABLE between T.spaces? 3) What is the use of MOVING the TABLE between SCHEMA'S? 4) What are the Table Clause, Segment Clause and the Datafile Clause which will override each other? 5) Explain SORT_AREA_SIZE of Tempfile to make UNIFORM SIZE

1578


Give the different types of rollback segments.

573


What is the parameter mode that can be passed to a procedure?

568


How to specify default values in insert statement using oracle?

556


How to use attributes of the implicit cursor in oracle?

556


what happened to the global index when I truncate the data in one of the partition?

1515


How to view all columns in an existing table?

547


What is a schema in oracle?

536


Can objects of the same schema reside in different tablespace?

584