Which SQL command marks the finalization of a database transaction?

• A. Rollback
• B. Commit
• C. Savepoint
• D. End Transaction

Answer: (B)

When a set of operations should all happen together as one unit, you’re working with a transaction. The action that finalizes this unit and makes all the changes permanent is committing. Committing ends the current transaction and writes the changes to the database so they cannot be undone as part of that transaction, ensuring durability. If something goes wrong, you’d roll back, which undoes everything within the transaction and ends it. A savepoint marks a specific point within the transaction to which you can roll back later, but it doesn’t complete the transaction itself. End Transaction isn’t the standard command used to finish a transaction in most SQL dialects.