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 purpose of normalization?
What is self contained sub query?
How do you drop an index?
Can sql servers link to other servers?
Is resultset an interface?
What is transaction server auto commit?
How to sort the query output with order by clauses in ms sql server?
What is 2nf in normalization?
Explain different types of locks in sql server.
What are the new features of sql server 2012 reporting service?
what is sql server? : Sql server database administration
How to copy data from one table to another table?
How to create indexed view?
can SSRS reports Cache results?
You want your report to display a hyperlink that will take users to your intranet. How do you configure such a hyperlink?