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

› Category: SQL ›  _________ command makes the updates performed by the transaction permanent in the database?
0 Vote Up Vote Down
Editor">Editor Staff asked 2 years ago

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

  1. ROLLBACK
  2. COMMIT
  3. TRUNCATE
  4. DELETE
Question Tags:
1 Answers
0 Vote Up Vote Down
Editor">Editor Staff answered 2 years ago

Answer:
2.COMMIT
Explanation:
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.