What is a transaction and what are ACID properties?

Answer Posted / srivas

A transaction is a logical unit of work in which, all the
steps must be performed or none. ACID stands for Atomicity,
Consistency, Isolation, Durability. These are the properties
of a transaction.

Is This Answer Correct ?    8 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

what are database files and filegroups? : Sql server database administration

666


How will you go about resolving deadlocks?

697


What structure can you implement for the database to speed up table reads?

943


What are the new features in SQL Server 2005 when compared to SQL Server 2000?

845


how can you attach more than 20 ldf files in sql server

1744






Write down the syntax and an example for create, rename and delete index?

723


What are the requirements to use odbc connections in php scripts?

807


Explain “row_number()” in sql server with an example?

721


Explain the database you used in your final year project?

712


How check triggers in sql server?

672


what's the information that can be stored inside a bit column? : Sql server database administration

723


What is a user-defined function in the sql server and what is its advantage?

819


How to verify a login name with sqlcmd tool?

792


What is the contrast amongst drop and truncate?

755


Where views are stored in sql server?

723