Answer Posted / hari

Cursor : Curosr is allow row processing of the result set.
Static
Dynamic
forward-only
Key setdriven

What stored procedure would you use to view lock information?

515

---

How column data types are determined in a view?

526

---

Explain mixed authentication mode of sql server?

539

---

What is difference between index and primary key?

576

---

Delete duplicate rows without using rowid.

1061

---

---

Explain an incremental backup?

580

---

How to find tables without indexes?

620

---

What command is used to rename the database?

520

---

What type of Index will get created after executing the above statement?

631

---

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

586

---

What are the security related catalog views? : sql server security

526

---

Explain about integration services of Microsoft SQL server?

574

---

What is a field name?

507

---

Define clusters?

641

---

What is database black box testing?

601

---