241
SQL Server Interview
Advanced Transactions & Concurrency
SQL Server interview questions covering advanced transactions & concurrency.
20 Questions Filter by level
Interview questions
Open a question for the full answer, code and interview guidance.
242
What is optimistic concurrency control?
243
What is the rowversion data type?
244
How do you implement optimistic concurrency with rowversion?
245
What is a lost update?
246
What is a dirty read?
247
What is a non-repeatable read?
248
What is a phantom read?
249
What is lock escalation?
250
What are intent locks?
251
What is an update lock and why does SQL Server use it?
252
What are key-range locks?
253
What is READ_COMMITTED_SNAPSHOT (RCSI)?
254
What is the difference between RCSI and SNAPSHOT isolation?
255
What is a snapshot update conflict?
256
What is the version store?
257
How do you capture and analyze a SQL Server deadlock?
258
How should an application handle deadlock error 1205?
259
How can transaction scope in ASP.NET Core affect SQL Server concurrency?
260