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

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

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,

Explain the rollup operator?

0 Answers  

Explain about the relational database?

0 Answers  

agregator gives one to many records or many to one record

1 Answers   IBM,

How long can an error message be in raiseerror function?

0 Answers  

You have a table with three columns: amount1, amount2, and amount3 in a single row only one of these three columns will have a value and the other two will be null. Write a sql query to retrieve the values from these columns?

0 Answers  

What is the maximum length of an extended property?

0 Answers  

how will I find the duplicate rows count from employees tablein oracle.

2 Answers  

Explain about normal forms?

0 Answers  

Define candidate key, alternate key, composite key?

30 Answers   IAS, IBM,

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

0 Answers  

For more DB Development Interview Questions Click Here
Categories