This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
What happens to nested transactions when the outer transaction is rolled back?
The inner transaction is executed.
The inner transaction prevents the outer transaction from being rolled back. Both the inner and outer transaction will be executed.
The inner transaction is also rolled back.
Which of the following T-SQL keywords are used to control transactions?
BEGIN TRANSACTION
BEGIN TRY
BREAK
What does XACT_STATE test for?
Whether there are nested transactions.
The status of the current request.
Returns the error number that caused the transaction to fail.
What is the default transaction isolation level for Azure SQL Database?
READ_COMMITTED_SNAPSHOT_ON
READ_COMMITTED_SNAPSHOT_OFF
XACT_ABORT
You must answer all questions before checking your work.
Was this page helpful?