What are the disadvantages of cursors? How can you avoid
cursors?
- 2 Answers
- 9686 Views
- I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
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 |
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 |
What is the physical representation for a many-to-many relationship?
Does QTP Support the Propjects which are running in Dot Net? As we are starting with new project in Dot net need to use automation tool?Please advice & let me know what would be the best.
Explain about a primary key?
Given an employee table, how would you find out the second highest salary?
Explain about normal forms?
What is an application role and explain a scenario when you would use one?
Explain the rollup operator?
What is a join and explain different types of joins?
How can you log an error to the server event log from a stored procedure?
Write short notes on manual refreshes.
What is the maximum length of an extended property?
Which four data types cannot be used as a return type from a user-defined function?
-
Oracle (3239) - SQL Server (4518)
- MS Access (429)
- MySQL (1402)
- Postgre (483)
- Sybase (267)
- DB Architecture (141)
- DB Administration (291)
- DB Development (113)
- SQL PLSQL (3312)
- MongoDB (502)
- IBM Informix (50)
- Neo4j (82)
- InfluxDB (0)
- Apache CouchDB (44)
- Firebird (5)
- Database Management (1391)
- Databases AllOther (288)
