What is replication and database mirroring?

1059

---

What is shared lock?

911

---

Explain the advantages of merge replication?

966

---

Explain hostprotectionattribute in sql server 2005?

1045

---

What is exclusive locks?

975

---

What is update locks?

904

---

Determine when an index is appropriate?

1092

---

Can you explain important index characteristics?

1002

---

Explain the purpose of indexes?

991

---

Explain full-text indexing?

1005

---

Do you know clustered and non-clustered index?

987

---

Explain the difference between clustered and non-clustered index?

934

---

Explain having clause and where clause?

1067

---

Explain indexes disadvantages?

1107

---

Explain what is it unwise to create wide clustered index keys?

995

---