Question 7 (2points)
Which of the following is NOT a transactional statement inT-SQL.
Question 7 options:
COMMIT TRAN
ROLLBACK TRAN
BEGIN TRAN
UNDO TRAN
Question 8 (2points)
@@TRANCOUNT describes the level of nesting of transactions.
Question 8 options:
True
False
Question 9 (2points)
Not every commit makes data permanent in T-SQL.
Question 9 options:
True
False
Question 10 (2points)
By default, T-SQL will wait 5,000 milliseconds when onetransaction is blocked by another.
Question 10 options:
True
False
Solution