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 oltp (online transaction processing)?

951

---

What do you mean by acid?

937

---

What are the advantages of using a stored procedure?

939

---

What is the difference between left and right outer join?

1017

---

how can you find out if the current user is a member of the specified microsoft® windows nt® group or microsoft sql server™ role? : Sql server administration

925

---

Why olap is used?

919

---

What does executeupdate return?

927

---

Write a SQL query to delete a table?

1078

---

Is INSTEAD OF trigger directly applicable to Table ?

957

---

Write the queries for commands like Create Table, Delete table, Drop Table etc.

1031

---

what is new philosophy for database devises for sql server 7.0? : Sql server database administration

952

---

List the various tools available for performance tuning?

843

---

Does sql server 2016 have ssms?

911

---

What is the recovery model?

931

---

How many null values we can have in a unique key field in sql server?

903

---