Multiple choice technology databases

Which of the following options is FALSE about unchained mode in ASE

  1. A commit tran is always implied for every transaction.

  2. Unchained mode is the default mode in ASE

  3. The server does not issue the begin tran implicity

  4. The value of @@tranchained is 0

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

In unchained mode, explicit transactions initiated with 'begin transaction' still require an explicit 'commit transaction' to persist. A commit is not automatically implied for explicit transactions, making this statement false.