Why use identity in sql server?

1117

---

What is a coalesce function?

1206

---

What are the different subsets of sql?

1564

---

List the ways in which dynamic sql can be executed?

1025

---

What is subquery in sql?

1078

---

List some case manipulation functions in sql?

1043

---

Which sql server table is used to hold the stored procedure script?

960

---

What is the significance of master, tempdb and model databases?

1092

---

Explain alternate key, candidate key and composite key in sql server?

921

---

Due to some maintenance being done, the sql server on a failover cluster needs to be brought down. How do you bring the sql server down?

1342

---

How to find the second highest salary of an employee?

1197

---

What is the main difference between ‘between’ and ‘in’ condition operators?

1209

---

How to make a remote connection in a database?

988

---

Can we write a distributed query and get some data which is located on other server and oracle database?

1244

---

Explain the first normal form(1nf)?

1039

---