Answer Posted / bhanu pratap singh

XP stands for-----Extreme Process

Explain what is “asynchronous” communication in sql server service broker?

872

---

Explain about merge replications?

967

---

Is foreign key unique?

959

---

How would you add a section to a table?

970

---

What is self contained multi valued query?

951

---

Does server sql treat char as a variable-length or fixed-length column?

954

---

How to see existing views in ms sql server?

989

---

What is the status of services on passive node for failover cluster in sql server? : sql server database administration

1169

---

How to delete a login name in ms sql server?

1006

---

Differentiate between sql temp table vs table variable?

835

---

What is data source object?

952

---

What is difference between standardization and normalization?

1021

---

Explain concepts of analysis services?

893

---

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

940

---

What are the types of lock supported by ?

996

---