Thursday, January 6, 2011

22 important SQL Server interview questions on Transaction and Locks

22 important SQL Server interview questions on Transaction and Locks


This section will cover the most asked SQL Server interview questions by the interviewer so have a look on the following and do revise it when ever you go for the SQL Server interview

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.

No comments: