0 votes
in Sql by
_________ 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

1 Answer

0 votes
by

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.

Related questions

+1 vote
asked Jan 13, 2022 in Angular Oriana by DavidAnderson
0 votes
asked Aug 13, 2023 in Other by SakshiSharma
...