Answer Posted / sanjeev kumar

Dead Lock:
Deak Lock is a situation when two or more process
continuous working and each having a lock on a particular
record but at a time only one can lock a particular and the
other one will go to dead lock

Live Lock:
A human example of live lock would be two people who meet
face-to-face in a corridor and each moves aside to let the
other pass, but they end up moving from side to side without
making any progress because they always move the same way at
the same time and never cross each other. This is good
example of live lock.

How many clustered indexes can be created on a table? I create a separate index on each column of a table. what are the advantages and disadvantages of this approach?

1053

---

What are the advantages of policy management?

942

---

What is scheduled job and how to create it?

923

---

How to replace the Query Result 'Null Value' with a text ?

971

---

What are the requirements on sql server network connections?

896

---

Explain database normalization?

1148

---

What is log in sql server?

1075

---

What is advantage data architect?

865

---

What is surrogate key? : sql server analysis services, ssas

1053

---

Is there any performance difference between if exists (select null from table) and if exists (select 1 from table)?

901

---

What is a natural primary key?

951

---

Is sql server 2016 free?

884

---

Do you know spatial data types - geometry and geography in sql server 2008?

968

---

What is difference statement and preparedstatement?

933

---

What are the types of user defined functions in sql server?

988

---