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

Where is dbms used?

0 Answers  

You are testing the performance of a query the first time you run the query, the performance is slow. the second time you run the query, the performance is fast. why is this?

0 Answers  

What is an extended stored procedure?

1 Answers  

On friday, you issued several insert statements using query analyzer. You then verified the data had been correctly entered with a select statement on monday, your users report that the data is not there what happened?

0 Answers  

Explain about the database management systems.

0 Answers  

What is a database development?

0 Answers  

explain detail about ftp in datastage?

0 Answers   IBM,

agregator gives one to many records or many to one record

1 Answers   IBM,

Explain about query and reporting.

0 Answers  

What is bit datatype and what's the information that can be stored inside a bit column?

2 Answers  

How can I detect whether a given connection is blocked?

0 Answers  

Pgm A calls Pgm B and pgm B uses cursor, when pgm B is called second time, the program is abending saying the cursor is opened? Why?

0 Answers   IBM,

For more DB Development Interview Questions Click Here
Categories