[Solved] What does the COMMIT command do in a database transaction? — Ans: It saves all changes made during the transaction permanently. | SQL

SQL - Transactions and Data Integrity

What does the COMMIT command do in a database transaction?

AIt locks the database to prevent changes.

BIt undoes all changes made during the transaction.

CIt starts a new transaction.

DIt saves all changes made during the transaction permanently.

Step-by-Step Solution

Solution:

Step 1: Understand the purpose of COMMIT
The COMMIT command finalizes all changes made in the current transaction and saves them permanently in the database.
Step 2: Compare with other options
ROLLBACK undoes changes, starting a transaction is done by BEGIN or START TRANSACTION, and locking is a different operation.
Final Answer:
It saves all changes made during the transaction permanently. -> Option D
Quick Check:
COMMIT = Save changes permanently [OK]

Quick Trick: COMMIT means save changes permanently [OK]

Common Mistakes:

Master "Transactions and Data Integrity" in SQL

9 interactive learning modes - each teaches the same concept differently

More SQL Quizzes

What does the COMMIT command do in a database transaction?