Answer Posted / smart bro

XP stands for extended store procedure

What do you know about normalization and de- normalization?

972

---

What are various aggregate functions that are available?

1044

---

Do you know what is a linked server in sql server?

1071

---

What is policy based management (pbm)? : sql server database administration

1032

---

What is table constraint?

1052

---

what are database files and filegroups? : Sql server database administration

1000

---

what's new in sql server 2016?

1003

---

How to create a view on an existing table in ms sql server?

1194

---

What do you mean by normalisation?

1112

---

How can we solve concurrency problems?

1098

---

What is dml command?

1020

---

What is the process of normalising?

1049

---

What is auditing in sql server?

969

---

What are data files?

1094

---

explain different types of joins? : Sql server database administration

1035

---