Answer / rahul kumar

A) In cursors each time you fetch a new row it does a round
trip with the database thereby increase network use and time.

B) There is also restriction on select statements that can be
used in cursors

C) It also uses more resources and temporary memory

Cursors can be avoided with the help of careful
implementation of while loop and other set based operations

Answer / gogune s k

Overload for RAM to process each row and time consuming.
Bulk collect can be used in place of cursors in some cases.

How to replace not in with not exist?

1 Answers  

---

What is data modeling with example?

1 Answers  

---

What is the difference between a primary index and a secondary index? What is a duplicate data entry in an index? Can a primary index contain duplicates?

5 Answers   IBM,

---

Hi my program is accesing data from two db2 databases.what is the bind card for this program to genarate plan? how to specify the two owners and two qualifiers in bind card

1 Answers   TCS,

---

What is normalization? Explain different levels of normalization?

9 Answers   CG-VAK, Choice Solutions, College School Exams Tests, IBM, Wipro,

---

Write the difference between case version and decode version.

2 Answers  

---

Write the fastest query to find out how many rows exist in a table?

1 Answers  

---

Why does this query return 0?

1 Answers  

---

Explain about the database management systems.

1 Answers  

---

Explain about relational database management systems?

1 Answers  

---

Explain about a primary key?

1 Answers  

---

How would you design a database for an online site, which would average a million hits a day?

1 Answers  

---