Answer Posted / yoshita kundwani

Cursors can be considers as named result sets which allow a
user to move through each record one by one.

What is query and its types?

911

---

How many ways to create table-valued functions?

981

---

What are the different types of join?

1167

---

Who developed sql server?

932

---

Where are sql server usernames and passwords stored in the sql server?

1112

---

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

1024

---

How to locate and take substrings with charindex() and substring() functions?

1016

---

How do you handle datasets larger than 50 gb?

162

---

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

955

---

What is the data type of time?

961

---

What area unit the various kinds of info compression introduced in sql server 2008?

1073

---

What is a covered index?

935

---

How do you clear a log file?

1041

---

How is sql used in sql server?

1003

---

Explain about protocol layer present in SQL server?

1196

---