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

Can foreign key be deleted?

0 Answers  


How to recover from sql injection? : sql server security

0 Answers  


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

0 Answers  


What is an indexing technique?

0 Answers  


What are the different acid properties?

0 Answers  






What is the basic difference between clustered and a non-clustered index?

9 Answers   Infogain,


write query for fourth maximum salary from employee table

14 Answers   Mind Tree, SP Software,


What are the extra roles available in msdb? : sql server security

0 Answers  


WHICH IS THE BEST INSTITUTE IN HYD FOR "ORACLE"?

3 Answers  


Explain what are commit and rollback in sql?

0 Answers  


wat is tuff file in log shipping, wt is d use of tht file?

1 Answers   TCS,


What is cube dimension? : sql server analysis services, ssas

0 Answers  


Categories