Concepts and Architecture Question:
Download Job Interview Questions and Answers PDF
Tell me what are the uses of Rollback Segment?
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 Interview Questions And Answers
PDF
Previous Question | Next 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? |