Concepts and Architecture Question:

Tell me what are the uses of Rollback Segment?

Tweet Share WhatsApp

Answer:

Rollback segments are used to get data blocks to the original state when user issues a 'rollback' statementgive consistent data to a user, hiding uncommitted changes made by other users/sessionsto undo uncommitted changes during database recovery. After applying all changes recorded in the redo logs, Oracle uses rollback segments to undo uncommitted changes. Since rollback segments are stored in the database buffers, they are automatically protected by the redo log.

Download Oracle Architecture and Concepts PDF Read All 82 Oracle Architecture and Concepts Questions
Previous QuestionNext Question
Explain what are the components of Physical database structure of Oracle Database?Tell me what is difference between UNIQUE constraint and PRIMARY KEY constraint?