What is a transaction and what are ACID properties?

Answers were Sorted based on User's Feedback



What is a transaction and what are ACID properties?..

Answer / 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

What is a transaction and what are ACID properties?..

Answer / mobin sathupally

A transaction is a logical unit of work in which, all the
steps must be performed or none.A transaction follows four
properties(rules).These four properties are known as ACID.
ACID stands for Automocity,Consistency,Isolation and
Durability.

Is This Answer Correct ?    2 Yes 0 No

What is a transaction and what are ACID properties?..

Answer / rahul

transaction is only the reading or writing or both reading
and writing in a database. when we are reading from a
database that is transaction where the database is not
changing. in writing into database the database values can
be changed. we can do both reading and writing in a database.
to do these operations the database must have the acid
properties.

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More SQL Server Interview Questions

How To Make password Protected SQL Server 2005 Database i.e when i open SQL Server database then ask for password.

1 Answers  


What are wait types?

0 Answers  


Explain the difference between primary keys and foreign keys?

0 Answers  


Is it possible to import data directly from t-sql commands without using sql server integration services? If so, what are the commands?

0 Answers  


what is Archive old data?

1 Answers  






What is transaction server auto commit?

0 Answers  


Using the customer, and order table in northwind database, please write a query to produce xml?

0 Answers  


What are the source of constraints?

0 Answers  


What types of Joins are possible with Sql Server?

0 Answers   NA,


What are the different types of replication you can set up in sql server?

0 Answers  


What is the difference between ddl,dml and dcl commands?

0 Answers   BirlaSoft, Verifone,


what is the difference between delete table and truncate table commands? : Sql server database administration

0 Answers  


Categories