What is the the use of Rollback Segment?

Options
- Used to roll back a transaction
- They can be used to recover the selected tables to a consistent state in case of failures
- They ensure that transactions leave the uncommitted changes unnoticed.

CORRECT ANSWER : They ensure that transactions leave the uncommitted changes unnoticed.

Discussion Board
Rollback segments

A Rollback Segment is a database object containing before-images of data written to the database. Rollback segments are used to:
- Undo changes when a transaction is rolled back.
- Ensure other transactions do not see uncommitted changes made to the database.
- Recover the database to a consistent state in case of failures.

Prajakta Pandit 02-9-2017 05:31 AM

answer

Basically, three of the presented choices are correct. Rollback segments are used to rollback an uncommited transaction(choice #1, which does not make it clear whether transaction commited or not). They also used for read consistency(choice #4) as well as for database recovery (choice #3).

Nick 08-21-2014 06:08 AM

Write your comments


Enter the code shown above:

(Note: If you cannot read the numbers in the above image, reload the page to generate a new one.)


Related Content

Advertisement
 
▲