____ command makes the updates performed by the transaction permanent in the…

2023

____ command makes the updates performed by the transaction permanent in the database.

  1. A.

    ROLLBACK

  2. B.

    COMMIT

  3. C.

    TRUNCATE

  4. D.

    More than one of the above

  5. 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.

Explore the full course: Up Lt Grade Assistant Teacher 2025