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

Explain what a database is?

0 Answers  

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

0 Answers   TCS,

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

2 Answers  

Explain about a primary key?

0 Answers  

Explain the family trees and connection by clause.

1 Answers  

what is Normalization?

6 Answers   TCS,

What are the 18 schemas?

0 Answers  

agregator gives one to many records or many to one record

1 Answers   IBM,

Write short notes on XSU and JAVA

1 Answers  

To convert IDMS to DB2, how to deal with IDMS occurs and redefined clause?

0 Answers  

What is denormalization and when would you go for it?

9 Answers   NBP,

Explain about relational operator join?

0 Answers  

For more DB Development Interview Questions Click Here
Categories