Do you know the isolation level that sql server support?

974

---

Explain optimistic and pessimistic concurrency?

1001

---

Explain the various types of concurrency problem?

1202

---

Do you know what are the differences between lost updates and uncommitted dependencies?

1095

---

What is sql server locking?

999

---

Do you know what guidelines should be followed to help minimize deadlocks?

984

---

Explain the benefits of user-defined functions?

1073

---

What is user-defined function? Explain its types i.e. Scalar and inline table value user-defined function?

918

---

Explain how dts is used to extract, transform and consolidate data?

1008

---

Explain the difference between functions and stored procedures in sql server?

994

---

What do you know about normalization and de- normalization?

934

---

What is built-in function?

1021

---

Explain database normalization?

1237

---

Do you know exporting and importing utility?

1051

---

Explain microsoft sql server functions?

1123

---