Question

In _______ transaction we include the DML statements that need to be executed as a unit.

(a) Explicit

(b) Implicit

(c) Distributed

(d) All of the mentioned

I got this question at a job interview.

I need to ask this question from Transaction topic in section Performance Tuning and Optimization of SQL Server

Answer 1

Right answer is (a) Explicit

To explain I would say: Generally we don’t include Select statement in a transaction.