Set - 8

Question 1 :

What are the different types of segments?

Answer :

Data segment, index segment, rollback segment and temporary segment.

Question 2 :

What is a data segment?

Answer :

Each non-clustered table has a data segment. All of the table's data is stored in the extents of its data segment. Each cluster has a data segment. The data of every table in the cluster is stored in the cluster's data segment.

Question 3 :

What is an index segment?

Answer :

Each index has an index segment that stores all of its data.

Question 4 :

What is rollback segment?

Answer :

A database contains one or more rollback segments to temporarily store "undo" information.

Question 5 :

What are the uses of rollback segment?

Answer :

To generate read-consistent database information during database recovery and to rollback uncommitted transactions by the users.