Question

_________ command makes the updates performed by the transaction permanent in the database?

Select the correct answer from below options:

a) ROLLBACK

b) COMMIT

c) TRUNCATE

d) DELETE

Answer 1

b) COMMIT

The COMMIT statement is a transactional command used to end the current transaction and make all changes performed in the transaction permanent.

The ROLLBACK statement is a transactional command used to back out or cancels the current transaction changes and restores changed data in its previous state.

TRUNCATE and DELETE are not transactional commands.