Introduction
EXEC runs all the commands queued in a transaction together. It helps make sure multiple commands happen at the same time.
When you want to update several pieces of data at once without interruption.
When you need to execute all commands atomically.
When you want to avoid other changes happening between your commands.
When you want to group commands to improve performance by sending them together.