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

What is the use of MOVE keyword in restore command

3 Answers   IBM,


What is difference between TRUNCATE and DELETE statement

12 Answers   CTS,


Can a stored procedure call itself(recursive). If yes what level and can it be controlled.?

2 Answers  


What is simple indexing method?

0 Answers  


What is the security principal at the database level that represents your session?

0 Answers  






What is a unique key constraint?

0 Answers  


What is filter index?

0 Answers  


How to create a view and a stored procedure in ms sql server using "create view/procedure" statements?

0 Answers  


Explain what is row_number function?

0 Answers  


What is function of CUBE ?

0 Answers   HCL,


What are the methods used to protect against sql injection attack?

0 Answers  


What is standby servers? Explain types of standby servers.

0 Answers  


Categories