Which built-in function returns the number of active transactions?
Ans: @@TRANCOUNT

http://www.interviewquestionspdf.com/2017/07/which-built-in-function-returns-number.html
Ans: @@TRANCOUNT
Here you will find all type of interview questions with answers, Most famous set is SQL Server Interview Questions.