Interested to Buy Any Domain ? << Click Here >> for more details...
Answer Posted / ashwin mane
Cursors do provide a number of benefits. These benefits
follow from the fact that if you do not use a cursor, the
entire result set must be transferred to the client for
processing and display:
1.Client-side memory - For large results, holding the
entire result set on the client can lead to demanding
memory requirements.
2.Response time -Cursors can provide the first few rows
before the whole result set is assembled. If you do not use
cursors, the entire result set must be delivered before any
rows are displayed by your application.
3.Concurrency control -If you make updates to your data
and do not use cursors in your application, you must send
separate SQL statements to the database server to apply the
changes. This raises the possibility of concurrency
problems if the result set has changed since it was queried
by the client. In turn, this raises the possibility of lost
updates.
Cursors act as pointers to the underlying data, and so
impose proper concurrency constraints on any changes you
make.
| Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
List the difference between asynchronous and synchronous transport?
when ever i try to installed sap ecc6.0 sr2 on single system. it show error on phase import abap "Not all objects are successfully processed. DIAGNOSIS: for details see output file with invalid object invalid_objects.txt and log file object_checker.log . SOLUTION: normally it indicate the data load error but in some special cases( for example if some object were created or loaded externally) you can press ok to continue" here error sentence is complete. pls tell what actual error its? is it kernel file related?
At os level how you can change the number of work process? How you can analyze the status of work process at os level?
What are common transport errors and their codes?
How to do transport at OS level?
What are the activities you done in EP?
How will u send mail after completion of backup?
What are the daily activates?
What is rfc connection?
How database extend?
On a particular system how you can get a list of the users with development access on a particular system?
What is the difference between Party & Service without party in XI (ID)?
How to identify a particular T_Code has been modified or not? If yes, how to identify who modified particular T_Code in current system?
Explain what is sap ides?
How you can restrict multiple logins of user in sap? What are the thing you have to take care of while writing the id’s?
