please differentiate between delete and truncate?

991

---

Do you know data definition language, data control language and data manipulation language?

1040

---

Do you know what is recursion? Is it possible for a stored procedure to call itself or recursive stored procedure? How many levels of sp nesting is possible?

1038

---

How to search for a string in all stored procedure in sql server?

997

---

Explain what is scheduled job and how to create it?

954

---

Tell me about builtinadministrator?

999

---

Do you know what is xpath?

1083

---

What is public role in sql server?

1145

---

Explain full-text query in sql server?

1003

---

Do you know how to make remote connection in database?

963

---

Tell me what are the advantages of using stored procedures?

1009

---

How to make remote connection in database?

1005

---

Explain what are the different index configurations a table can have?

1109

---

Tell me what is difference between view and materialized view?

937

---

Tell me the use of keyword with encryption. Create a store procedure with encryption?

1005

---