A transaction in a database system terminates either by a commit (making changes permanent) or a rollback (undoing all changes). Options A and B are incomplete as they only consider one termination mode. Option D is incorrect because transactions do end through these two mechanisms - there are no other ways to complete a transaction.