Answer Posted / nalini

Cursor is the current position of recordset.There are 4
types of cursors.
1.forward Only (Default)
2.Static
3.Keyset
4.Dynamic

Explain the working of sql privileges?

595

---

How to modify an existing stored procedure in ms sql server?

521

---

How many types of triggers are there?

560

---

you have a table with close to 100 million records recently, a huge amount of this data was updated now, various queries against this table have slowed down considerably what is the quickest option to remedy the situation? : Sql server administration

531

---

What are tables in sql server?

522

---

---

What are difference between Cluster index and Non-Cluster index?

599

---

Explain isolation levels that sql server supports?

561

---

What is data compression?

539

---

SQL Server Architecture ?

1917

---

Explain the categories of stored procedure?

508

---

What are the various Operating system files that every SQL server 2005 database has and what is the purpose.

585

---

How do I open port 1433?

509

---

What happens if date-only values are provided as date and time literals?

528

---

What is database black box testing?

601

---

what method you can use to reduce the overhead of Reporting Services data sources?

145

---