Tento prehliadač už nie je podporovaný.
Inovujte na Microsoft Edge a využívajte najnovšie funkcie, aktualizácie zabezpečenia a technickú podporu.
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.
Bola táto stránka užitočná?
Potrebujete pomôcť s touto témou?
Chcete si vyskúšať použitie funkcie Ask Learn na objasnenie alebo predstavenie tejto témy?