Q25
Which of the following command makes the updates performed by the transaction permanent in the database?
A.
ROLLBACK
B.
COMMIT
AnswerC.
TRUNCATE
D.
DELETE
Answer: Option B
Solution
Answer: Option B
Solution:
In SQL, the command that makes the updates performed by a transaction permanent in the database is the COMMIT command. When you issue the COMMIT command, it finalizes all the changes made within the current transaction, ensuring that they are saved to the database and cannot be rolled back.ROLLBACK (Option A) is used to undo the changes made during the transaction and return the database to its previous state.
TRUNCATE (Option C) is used to quickly delete all rows from a table, but it's not used to make changes performed by a transaction permanent.
DELETE (Option D) is used to remove specific rows from a table, but it doesn't finalize changes across an entire transaction.
So, Option B, the COMMIT command, is the correct choice for making transaction updates permanent in the database.