What is a transaction and what are ACID properties?

Answer Posted / piyush

transaction is a set of operation or activities which are
executed in a logical unit of work which is know as transaction.

ACID
A-Atomicity
C-Consistency
I-Isolation
D-Durability

Is This Answer Correct ?    28 Yes 8 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

what is database replicaion? : Sql server database administration

615


How much is a sql server license?

514


What is sql server programming?

561


You want to use a perspective in an mdx query. How do you select the perspective?

157


Explain log shipping?

593






how you can list all the tables in a database?

534


Do you know the policy based administration feature of sql server 2008?

585


What is difference between getdate and sysdatetime in sql server 2008?

608


What is indexed view?

606


What are relationships and mention different types of relationships in the dbms

565


Why variables called the most powerful component of ssis?

599


How to perform key word search in tables?

538


What is difference between group by and having?

568


Can we use pragma autonomous_transaction in trigger?

550


Where to find ntwdblib.dll version 2000.80.194.0?

567