What is a transaction and what are ACID properties?

Answer Posted / kumar

a transaction is a set of operations perfomed on a database.
After a transaction is done it is commited.

Is This Answer Correct ?    10 Yes 8 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

How to define output parameters in stored procedures?

713


How are the unique and primary key constraints different?

790


What is set nocount on and what is set nocount off?

674


Suggest a method of joining two tables.

815


Explain concepts of analysis services?

679


To which devices can a backup be created and where should these devices be located? : sql server management studio

737


How to create a trigger for insert only?

767


Explain triggers?

762


mention different types of relationships in the dbms?

703


If no size is defined while creating the database, what size will the database have?

749


Tell me when is the update_statistics command used?

706


What are the differences between web role and worker role?

116


What happens when unicode strings concatenate with non-unicode strings?

735


How you can move data or databases between servers and databases in sql server?

770


Differentiate sql server reporting services vs. Crystal reports?

168