What is a transaction and what are ACID properties?
Answer Posted / kumar
The ACID model is one of the oldest and most important
concepts of database theory. It sets forward four goals
that every database management system must strive to
achieve: atomicity, consistency, isolation and durability.
No database that fails to meet any of these four goals can
be considered reliable.
•Atomicity states that database modifications must follow
an “all or nothing” rule. Each transaction is said to
be “atomic.” If one part of the transaction fails, the
entire transaction fails. It is critical that the database
management system maintain the atomic nature of
transactions in spite of any DBMS, operating system or
hardware failure.
•Consistency states that only valid data will be written to
the database. If, for some reason, a transaction is
executed that violates the database’s consistency rules,
the entire transaction will be rolled back and the database
will be restored to a state consistent with those rules. On
the other hand, if a transaction successfully executes, it
will take the database from one state that is consistent
with the rules to another state that is also consistent
with the rules.
•Isolation requires that multiple transactions occurring at
the same time not impact each other’s execution.
.Durability ensures that any transaction committed to the
database will not be lost. Durability is ensured through
the use of database backups and transaction logs that
facilitate the restoration of committed transactions in
spite of any subsequent software or hardware failures
Is This Answer Correct ? | 20 Yes | 7 No |
Post New Answer View All Answers
I have a table Events Events containing cardno,time,id,name--each id has a cardno my requirement is every day each employee swipe the card several times i want to calculate first and last time of each card the output should be name 1 2 6 7 in out in out holiday holiday xxx 09:30 06:30 09:40 06:45 where 1,2...... are dates for example january 1,2, etc. 6 and 7 are saturday and sunday how it is posssible
What is difference between after and before?
Why variables called the most powerful component of ssis?
What is policy management?
How to add code to the existing article (using improve article)?
What is the preferred way to create a clustered and non-clustered index? Which index should you create first the clustered or non-clustered?
What triggers long term care?
Explain the microsoft sql server delete command?
What is the architecture of ms sql reporting service?
What are secondary xml indexes?
what's the difference between delete table and truncate table commands? : Sql server database administration
What are the different types of columns types constraints in the sql server?
Explain the etl (extraction, transformation, and loading)?
What are functions in the sql server?
what is datawarehouse?