Multiple choice technology databases

Which @@ gobal variable can tell you the tranasction mode of a session

  1. is_chained

  2. tran_chained

  3. chained

  4. tranchained

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

The @@tranchained global variable returns the current transaction mode: 1 for chained mode (implicit transactions where each statement auto-commits unless in a transaction) or 0 for unchained mode (explicit transaction control with begin/commit).