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
Suppose we have a table "MyTable" containing 10 rows, what query should be executed to update the odd rows "Salary" as 9000?
What is co-related sub query?
What is 'write-ahead log' in sql server 2000 ?
Can you explain powershell included in sql server 2008?
What is subreport?
How to test odbc dsn connection settings?
Explain nested stored procedure. Syntax and an example for create nested stored procedure?
What is use of except clause?
What are views in ms sql server?
How to choose all records from the table?
write an SQL query to list the employees who joined in the month of January?
role of sql sever 2005 in database rather than any other database
What are data files?
What is an execution plan?
In which sql server version report builder introduced?