Recap of some of the different consistency guarantees you get on different relational databases. In particular for Oracle the second image explains how the redo logs and undo table are used to guarantee some ACID properties.

DB_Transaction_Read_Consistency.svg DB_Oracle_Transaction_Persistency.svg