____ command makes the updates performed by the transaction permanent in the…
2023
____ command makes the updates performed by the transaction permanent in the database.
- A.
ROLLBACK
- B.
COMMIT
- C.
TRUNCATE
- D.
More than one of the above
- E.
None of the above
Attempted by 853 students.
Show answer & explanation
Correct answer: B
In database transactions, the COMMIT command is used to save all changes made during a transaction to the database, making them permanent. This ensures data consistency and durability. The ROLLBACK command, on the other hand, undoes all changes made during a transaction, reverting the database to its previous state. It is used when an error occurs or when the transaction needs to be canceled. The TRUNCATE command removes all rows from a table but does not affect the transaction state. It is not used to make transaction updates permanent. Therefore, the correct command that makes transaction updates permanent is COMMIT.