Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

  1. Categories >> Software >> Databases >> DB Development
  2. Suggest New Category

What are the disadvantages of cursors? How can you avoid
cursors?

Question Posted / guest

Answers were Sorted based on User's Feedback



What are the disadvantages of cursors? How can you avoid cursors?..

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

Is This Answer Correct ?    13 Yes 2 No

What are the disadvantages of cursors? How can you avoid cursors?..

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.

Is This Answer Correct ?    3 Yes 1 No

Post New Answer

More DB Development Interview Questions

what is Normalization?

6 Answers   TCS,

Explain the family trees and connection by clause.

1 Answers  

How is data stored in dbms?

0 Answers  

what is architecture of your datastage project??? i came across this question many times in interviews in specific what can i answer plz help me

1 Answers   IBM,

What is data modeling with example?

0 Answers  

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

0 Answers  

Explain the rollup operator?

0 Answers  

What are the 18 schemas?

0 Answers  

How to generate OIDS

0 Answers  

What are triggers? How many triggers you can have on a table?

2 Answers   Ramco,

Hi , any one can help me on the same,this is regarding the Informatica Function doc,i want to know how developer is will develop the mapping. pl forwar the any function doc .just for my references. svlc75@yahoo.co.in

0 Answers   Covansys,

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

0 Answers  

For more DB Development Interview Questions Click Here
Categories