October 17, 2022 at 12:00 am
Comments posted to this topic are about the item Autocommit Transactions
October 17, 2022 at 10:21 am
In the implicit transaction mode, SQL Server takes the responsibility for beginning the transactions implicitly but it waits for the commit or rollback commands from the user.
Therefor Answer A is not the case
October 17, 2022 at 12:44 pm
I would buy explanation given here if it wasn't supported by ms docs link which says
Implicit transactions
A new transaction is implicitly started when the prior transaction completes, but each transaction is explicitly completed with a COMMIT or ROLLBACK statement.
and
Autocommit transactions
Each individual statement is a transaction.
So, in autocommit mode transactions for dml will be implicitly opened and closed but they are not "implicit transactions" which (since implicit mode was introduced) have to be explicitly closed.
October 18, 2022 at 3:01 pm
The question has been adjusted. My mistake for miswording things.
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply