What are the main purposes of a database transaction?
Defined by the acronym ACID, which stands for Atomic, Consistent, Isolated and Durable. This means that when doing an INSERT, UPDATE or DELETE they are usually permanent. When one of these actions is done it is independent of any other operation. It doesn't interfere with any other operations and it's persistent, it's there for good.