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 database white box testing?
Suppose you want to implement the many-to-many relationships while designing tables. How would you do it?
What do you mean by cardinality?
Tell me what are cursors and when they are useful?
How the authentication mode can be changed?
If any stored procedure is encrypted, then can we see its definition in activity monitor?
how you can deploy an ssrs report?
Explain the database you used in your final year project?
What is a deadlock and what is a live lock?
What is 2nf normalization form?
Can we check locks in database? If so, how can we do this lock check?
How many non clustered indexes there can be on table ?
How can I know what locks are running on which resource?
What is the use of custom fields in report?
What is field in algebra?