What is a transaction and what are ACID properties?
Answer Posted / abdul malik(new college)
A-Atomacity
C-Consistency
I-Isolation
D-Durability
Atomacity-eiher all operations of the transaction are
reflected properly in the database are none all.
Consistency-Execution of transaction in isolation (ie)with
no other transaction executing concurrently.preserve
the consistency of the database.
Isolation-even though multiple transaction may execute
concurrently.
Durablity-
after a transaction complete successfully the changes it has
made to the database presist even if there are system
failure.
These are called ACID properties.
| Is This Answer Correct ? | 17 Yes | 22 No |
Post New Answer View All Answers
What is difference between global temporary tables and local temporary tables?
What do you understand by the analysis services in sql server?
What were the latest updates to SQL Azure service?
What is the index requirement in SQL Azure?
What is the difference between dataadapter and datareader?
What is the command dbcc checkdb used for?
How to create view in stored procedure sql server?
plss anybody specify tha constrian management system in dbms
How to write a query with an inner join in ms sql server?
What is DCL?
What is the boxing and unboxing concept in .net?
What is the query and subquery?
Explain transaction server explicit transaction?
What is constraints and its types?
In case you have filters in your report, when filters will be applied in cached report instance?