What is key set driven?

971

---

Explain the cursor lock types?

1068

---

Suppose you want to implement the one-to-one relationships while designing tables. How would you do it?

968

---

Suppose you want to implement the one-to-many relationships while designing tables. How would you do it?

987

---

Suppose you want to implement the many-to-many relationships while designing tables. How would you do it?

1018

---

Explain the functionalities that views support?

1131

---

What are xml indexes?

962

---

What is the openxml statement in sql server?

1086

---

What is for xml in sql server?

1089

---

How to call stored procedure using http soap?

1086

---

Can you explain what is indexed view? How to create it?

920

---

Explain what are partitioned views and distributed partitioned views?

952

---

Do you know what are the restrictions that views have to follow?

1092

---

What are secondary xml indexes?

1040

---

What are the disadvantages of merge replication?

1439

---