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

1212

---

What do you mean by data integrity?

1136

---

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

1082

---

What is the cartesian product of the table?

1015

---

What is a deadlock and what is a live lock?

1049

---

Explain unique key in sql server?

1053

---

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

1021

---

What is the difference between primary key and unique constraints?

1021

---

Write a sql query to display the current date?

1152

---

Why use “in” clause in sql server?

1137

---

When would you use it?

1048

---

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

1095

---

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

1183

---

Explain about link server in sql server?

1127

---

What is the difference between delete and truncate statements?

1137

---