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.

What is explicit cursors?

1062

---

How do I clean up sql server transaction log?

1058

---

Tell me what is fill factor?

959

---

Difference between report and query parameter. Why do we need different type of parameter?

948

---

Suppose we have a table "MyTable" containing 10 rows, what query should be executed to update the odd rows "Salary" as 9000?

976

---

Mention the differences between local and global temporary tables.

1029

---

What are the differences between clustered and non-clustered index?

1022

---

How to create and drop temp table in sql server?

1049

---

What is GUID in sql server?

1159

---

How dts is used to extract, transform and consolidate data?

1069

---

What do we need queues in sql service broker?

1065

---

You are creating an application where users are asked their gender in the gender combo box you have three options: ‘male’ , ‘female’ and ‘i choose not to disclose’ these options are stored in the table as 1, 0 or null which datatype should you use?

1004

---

Explain optimistic and pessimistic concurrency?

990

---

What is logon trigger?

1085

---

What are the differences between stored procedure and view in sql server?

1239

---