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


Please Help Members By Posting Answers For Below Questions

What are the differences between proc means and proc summary?

608


explain what is factor analysis? : Sas-administrator

612


Explain input and put function?

657


What are the functions which are used for character handling functions?

624


Differentiate between proc means and proc summary.

612






Differentiate between ceil and floor functions.

670


how does sas handle missing values in formats? : Sas programming

598


Are you involved in writing the inferential analysis plan? Tables specifications?

3490


Give some examples where proc report’s defaults are different than proc print’s defaults?

607


What is a macro routine?

2110


what are the scrubbing procedures in sas? : Sas programming

844


For clinical entire study how many tables will create approx?

1530


How sas treats the dsd delimiters?

730


Describe the function and utility of the most difficult SAS macro that you have written?

2037


why is a stop statement needed for the point=option on a set statement? : Sas programming

596