Tarry: Since your post mentioned that even UNCOMMITTED data gets inside datafiles --

Lets say for instance you INSERTED 10 Rows into EMP Table and they were NOT COMMITTED. But lets assume these records went to the datafiles (as you mentioned).

Assume a power failure at this juncture. Next time when you start the database and select from EMP, do you think those rows would be there?

This question arised basically because you mentioned that even UNCOMMITTED rows go to datafiles, besides COMMITTED.

Hope I've made the question clear.