Answer Posted / santosh kumar sharma

There are 4 types of cursor.
1) Static: Cursor can move to any record but the changes on
the data can't be seen.
2) Dynamic: Most resource extensive. Cursor can move
anywhere and all the changes on the data can be viewed.
3) forward-only: Cursor moves one step forward. Can't move
backwards.
4) Key setdriven: Only Updated data can be viewed. Deleted
and Inserted data cannot be viewed.

Do you know the cursor types?

1124

---

List layers of abstraction microsoft architectured to provide relational db through cloud platform ?

181

---

Can we write trigger for view?

963

---

What are the Advantages of using CTE in sql server?

1065

---

What is the difference between substr and charindex in the sql server?

1019

---

Explain filtered indexes benefits?

963

---

What are the key configuration files for sql server reporting services ?

163

---

Do you know what is a trace frag? Where do we use it?

967

---

What are different types of statement?

958

---

Explain full-text query in sql server?

956

---

I have triggers,views,functions,stored Procedures for a table. When I am dropping that table which objects are deleted?

1095

---

How many triggers you can have on a table?

953

---

Why de-normalization required?

951

---

Can we call stored procedure in trigger?

916

---

What happens if null values are involved in bitwise operations?

980

---