Multiple choice

Which of the following commands makes the updates performed by the transaction permanent in the database?

  1. ROLLBACK

  2. COMMIT

  3. TRUNCATE

  4. DELETE

  5. None of these

Reveal answer Fill a bubble to check yourself
B Correct answer
Explanation

COMMIT transaction makes all data modifications performed since the start from the transaction from a permanent part of the database, it frees the resources held by the transaction.