What are the different types of lock modes in sql server 2000?
Explain the various types of concurrency problem. I.e. Lost or buried updates, uncommitted dependency, inconsistent analysis, phantom read?
What is optimistic concurrency?
Explain what are the events recorded in a transaction log?
What is pessimistic concurrency?
Do you know the isolation level that sql server support?
Explain optimistic and pessimistic concurrency?
Explain the various types of concurrency problem?
Do you know what are the differences between lost updates and uncommitted dependencies?
What is sql server locking?
Do you know what guidelines should be followed to help minimize deadlocks?
Explain the benefits of user-defined functions?
What is user-defined function? Explain its types i.e. Scalar and inline table value user-defined function?
Explain how dts is used to extract, transform and consolidate data?
Explain the difference between functions and stored procedures in sql server?