We should use transaction when several operations must succeed or fail as a unit.

The following are some frequent scenarios when we must use transactions:

1.  when multiple rows must be inserted or deleted or updated as a single unit

2. whenever a change to one table requires other tables to be updated

3. when modification of data is required in two or more databases, concurrently

4. where data is modified in databases in a different server