What is Transaction...? And what are Comment, Roll back n
Save point..?
Answer Posted / saifudheen
In computer programming, a transaction usually means a sequence of information exchange and related work (such as database updating) that is treated as a unit for the purposes of satisfying a request and for ensuring database integrity. For a transaction to be completed and database changes to made permanent, a transaction has to be completed in its entirety. A typical transaction is a catalog merchandise order phoned in by a customer and entered into a computer by a customer representative. The order transaction involves checking an inventory database, confirming that the item is available, placing the order, and confirming that the order has been placed and the expected time of shipment. If we view this as a single transaction, then all of the steps must be completed before the transaction is successful and the database is actually changed to reflect the new order. If something happens before the transaction is successfully completed, any changes to the database must be kept track of so that they can be undone.
Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
What are the differences between proc means and proc summary?
explain what is factor analysis? : Sas-administrator
Explain input and put function?
What are the functions which are used for character handling functions?
Differentiate between proc means and proc summary.
Differentiate between ceil and floor functions.
how does sas handle missing values in formats? : Sas programming
Are you involved in writing the inferential analysis plan? Tables specifications?
Give some examples where proc report’s defaults are different than proc print’s defaults?
What is a macro routine?
what are the scrubbing procedures in sas? : Sas programming
For clinical entire study how many tables will create approx?
How sas treats the dsd delimiters?
Describe the function and utility of the most difficult SAS macro that you have written?
why is a stop statement needed for the point=option on a set statement? : Sas programming