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.

What is an application role and explain a scenario when you would use one?

0 Answers  

---

How do you implement one-to-one, one-to-many and many-to- many relationships while designing tables?

1 Answers   Flextronics, Hexaware, SQL Star,

---

Explain the rollup operator?

0 Answers  

---

Does QTP Support the Propjects which are running in Dot Net? As we are starting with new project in Dot net need to use automation tool?Please advice & let me know what would be the best.

0 Answers  

---

How to use online Backups?

0 Answers  

---

---

What are the main phases of database development?

0 Answers  

---

agregator gives one to many records or many to one record

1 Answers   IBM,

---

How to combine two function together?

0 Answers  

---

If a column is an image value type, how you can compare column values? How can you use this column in join clause?

0 Answers  

---

What is the database development process?

0 Answers  

---

What are the three basic rules which are to be followed for the relational model of the database?

0 Answers  

---

What are the 18 schemas?

0 Answers  

---