Answer Posted / vikash kumar mishra

There are five type of cursors in SQL server.
1)Base table:- This is lowest level cursor.

2)Static :- This is scrollable query cursor in earlier
versions of SQL Server Compact Edition

3)Forward-only:- The forward-only cursor is the fastest
cursor that you can update, but it does not support
scrolling.

4)Forward-only/Read-only:- Forward-only/read-only cursors,
referred to as forward-only cursors in earlier versions of
SQL Server Compact Edition, are the fastest cursors, but
cannot be updated.

5)Keyset-driven:- The keyset-driven cursor in SQL Server
Compact Edition is a scrollable cursor that you can update.
A keyset-driven cursor is controlled by a set of physical
identifiers known as the keyset.

what is spatial nonclustered index

984

---

What are the requirements on sql server network connections?

980

---

What are the types of table?

978

---

What are cursors? Explain the different types of cursors Enlist a few disadvantages of cursors.

1261

---

Explain about sql server login?

1084

---

What are the different types of backups avaialabe in sql server 2005?

1017

---

Explain what role entity and relationship play in an ER diagram.

1069

---

What is a matrix in ssrs?

151

---

What is sql view?

1019

---

What is exporting utility?

1018

---

System variable and temporary variables

2250

---

When you should use a low fill factor?

990

---

How to add the custom code in Report?

126

---

How to use clusters?

943

---

What is transactional replication?

960

---