Multiple choice technology databases

Which of following will cause end of user transaction.

  1. Commit

  2. Drop

  3. Truncate

  4. All of above
Reveal answer Fill a bubble to check yourself
D Correct answer
Explanation

All three operations end a user transaction. COMMIT explicitly ends the transaction by saving changes. DROP and TRUNCATE are DDL operations that implicitly commit the current transaction and start a new one in most databases (Oracle, PostgreSQL). Therefore 'All of above' is correct.

Keep practicing — related questions