What is a join in sql? What are the types of joins?

1202

---

What do you mean by data integrity?

1131

---

How can we determine what objects a user-defined function depends upon?

1078

---

What is the cartesian product of the table?

1011

---

What is a deadlock and what is a live lock?

1048

---

Explain unique key in sql server?

1053

---

Can a stored procedure call itself or recursive stored procedure? How many levels sp nesting is possible?

1019

---

What is the difference between primary key and unique constraints?

1015

---

Write a sql query to display the current date?

1147

---

Why use “in” clause in sql server?

1130

---

When would you use it?

1046

---

What is the difference between ‘having’ clause and a ‘where’ clause?

1095

---

How to add code to the existing article (using improve article)?

1173

---

Explain about link server in sql server?

1120

---

What is the difference between delete and truncate statements?

1133

---