What is a transaction and what are ACID properties?
Answers were Sorted based on User's Feedback
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 |
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 |
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 |
Can foreign key be deleted?
How to recover from sql injection? : sql server security
To which devices can a backup be created and where should these devices be located? : sql server management studio
What is an indexing technique?
What are the different acid properties?
What is the basic difference between clustered and a non-clustered index?
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
WHICH IS THE BEST INSTITUTE IN HYD FOR "ORACLE"?
Explain what are commit and rollback in sql?
wat is tuff file in log shipping, wt is d use of tht file?
What is cube dimension? : sql server analysis services, ssas