What does a return value of -1 mean from the fun

More DBA job interview questions and answers at http://dba.fyicenter.com/Interview-Questions/

(Continued from previous question...)

What does a return value of -1 mean from the function XACT_STATE() in SQL Server 2005?

Answer: This indicates that the current transaction cannot be committed.
Explanation: This indicates the the current transaction has entered an uncommittable state.

(Continued on next question...)

Other Job Interview Questions

• What does a report model provide in SQL Server 2005 Reporting Services?
• Which of the following statements best describes the filter capabilities of Report Builder?
• Using Report Builder, which of the following is the best statement about the formatting options for boolean columns?
• You wish to back up the symmetric key used to protect data on the Reporting Services 2005 instance installed on Sales01. From your workstation, what command do you use?
• How can SQL Server Agent Mail send messages in SQL Server 2005?
• What does this return?
• Which is these is not necessary for a well-formed XML document?
• What happens when a transaction fails on the publisher?
• What does @@options return?
• What does this code return? select 6 | 7 Figure it out without running it.
• More...