141
SQL Server Interview
Transactions, Locking, Blocking & Deadlocks
SQL Server interview questions covering transactions, locking, blocking & deadlocks.
20 Questions Filter by level
Interview questions
Open a question for the full answer, code and interview guidance.
142
What are the ACID properties of a transaction?
143
What is COMMIT?
144
What is ROLLBACK?
145
What is an implicit transaction?
146
What is @@TRANCOUNT?
147
What is a SAVEPOINT in SQL Server?
148
What is XACT_STATE()?
149
What is a lock in SQL Server?
150
What are Shared, Exclusive, and Update locks?
151
What is blocking in SQL Server?
152
How can blocking be reduced?
153
What is a deadlock?
154
How can deadlocks be prevented or reduced?
155
What is a transaction isolation level?
156
What is READ UNCOMMITTED?
157
What is READ COMMITTED?
158
What are REPEATABLE READ and SERIALIZABLE?
159
What is SNAPSHOT isolation?
160