Answer / ramya gurrala

Cursor is a pointer(in c/java).Cursor work with DML and information can be accessed.

Cursor is required to process each row individually for queries which return multiple rows.

Advantages:1)We can do operations on each row.
2)Response time is good.
3)Cursors are faster than the while loop.

Disadvantages:1)Repeated network round trips.
2)Occupies more resources and temporary storage.

What is the difference between referencing and joining?

1 Answers  

---

What are the disadvantages of using the stored procedures?

0 Answers  

---

Define ACID properties in a Database?

0 Answers   iNautix,

---

How to check if a table is being used in sql server?

0 Answers  

---

How to recompile stored procedure at run time?

0 Answers  

---

Which are ddl commands?

0 Answers  

---

UPDATE statement can on a single table or on the multiple table?

7 Answers   iGate, TCS,

---

what is differece between union and union all

6 Answers  

---

What is Extended user-defined?

0 Answers  

---

What is user-defined function?

0 Answers  

---

What is row_number function?

0 Answers  

---

What is 2nf in normalization?

0 Answers  

---