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

939

---

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

1104

---

What are the different types of locks in the database?

939

---

Why use “pivot” in sql server?

1139

---

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

1410

---

What is built-in/administrator?

1029

---

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

969

---

What the different topologies in which replication can be configured?

1102

---

What is index, cluster index and nonclustered index?

1003

---

What is a recursive stored procedure in sql server?

1188

---

What is acid mean in sql server?

1134

---

What are the kinds of subquery?

1022

---

What is normalization and what are the advantages of it?

997

---

What are the properties of the transaction?

1018

---

What is sql or structured query language?

1161

---