What term describes a group of SQL statements that are executed as a single atomic unit?

• A. Module
• B. Batch
• C. Procedure
• D. Transaction

Answer: (D)

The idea here is that multiple SQL statements are meant to be executed as one indivisible operation. This is provided by a transaction. You start a transaction, run several statements, and then either commit to apply all changes or roll back to undo them. That guarantees atomicity—either everything happens, or nothing does—so related updates don’t leave the database in a partial or inconsistent state. A batch, by contrast, is simply a group of statements sent together; it doesn’t automatically ensure that all of them succeed or fail as a unit. A stored procedure is a reusable block of code that can contain many statements, and it can use transactions inside, but it isn’t defined by itself as the all-or-nothing unit. A module is just a broader code unit and isn’t specifically about transactional execution.