22 important SQL Server interview questions on Transaction and Locks
Normally SQL Server interview starts with…..
What is a “Database Transactions“?
What is ACID?
What is “Begin Trans”, “Commit Tran”, “Rollback Tran” and “SaveTran”?
What are “Checkpoint’s” in SQL Server?
What are “Implicit Transactions”?
Is it good to use “Implicit Transactions”?
What is Concurrency?
How can we solve concurrency problems?
What kind of problems occurs if we do not implement proper locking strategy?
What are “Dirty reads”?
What are “Unrepeatable reads”?
What are “Phantom rows”?
What are “Lost Updates”?
What are different levels of granularity of locking resources?
What are different types of Locks in SQL Server?
What are different Isolation levels in SQL Server?
What are different types of Isolation levels in SQL Server?
If you are using COM+ what “Isolation” level is set by default?
What are “Lock” hints?
What is a “Deadlock”?
What are the steps you can take to avoid “Deadlocks”?
How can I know what locks are running on which resource?
So friends answering to above question on Transaction and Locks of
SQL Server interview questions helped me to clear in front of the interviewer.