List out different types of normalizations in sql server and explain each of them?

977

---

What are the different authentication modes in sql server? How can it be changed?

1143

---

What are the different types of locks in the database?

978

---

Why use “pivot” in sql server?

1185

---

Is it possible to import data directly from t-sql commands without using sql server integration services? If so, what are the commands?

1462

---

What is built-in/administrator?

1082

---

What is the difference between a unique key and primary key?

1007

---

What the different topologies in which replication can be configured?

1152

---

What is index, cluster index and nonclustered index?

1056

---

What is a recursive stored procedure in sql server?

1254

---

What is acid mean in sql server?

1207

---

What are the kinds of subquery?

1079

---

What is normalization and what are the advantages of it?

1035

---

What are the properties of the transaction?

1057

---

What is sql or structured query language?

1202

---