Interested to Buy Any Domain ? << Click Here >> for more details...
what is cursor?why we will go to cursor?advantages &disadvantages of cursors?
- 1 Answers
- 3094 Views
- I also Faced
- E-Mail Answers
Answer Posted / ramya gurrala
Cursor is a pointer(in c/java).Cursor work with DML and information can be accessed.
Cursor is required to process each row individually for queries which return multiple rows.
Advantages:1)We can do operations on each row.
2)Response time is good.
3)Cursors are faster than the while loop.
Disadvantages:1)Repeated network round trips.
2)Occupies more resources and temporary storage.
| Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
How is foreign key related to primary key?
Explain the first normal form(1nf)?
What are the types of joins in sql?
What is bcnf normalization form?
explain different types of cursors? : Sql server database administration
How to rebuild indexes with alter index ... Rebuild?
What is row_number()?
What is the use of floor function in sql server?
Tell me about the approaches which you used to counter the DI problems.
How to grant a permission in ms sql server using "grant execute" statements?
How to get a list of columns using the "sp_help" stored procedure in ms sql server?
Does the unique constraint create an index?
Do you know what are the properties of the relational tables?
Explain something about security and SQL Azure?
Explain transaction server auto commit?
