I am trying to understand the below concepts with regards to internal concepts ( such as undo and redo)
1) what happens in the database when you insert a row in a table ?
2) what happens in the database when you update a row in a table?
3) what happens in the database when you delete a row a in the table??
I read the oracle documentation and got confused with the redo and undo behavior. It would you great if you someone explains the concept in a simple manner. I am a novice programmer trying to understand the database concepts . Any help would be highly appreciated.