What is a transaction and what are ACID properties?
Answer Posted / mobin sathupally
A transaction is a logical unit of work in which, all the
steps must be performed or none.A transaction follows four
properties(rules).These four properties are known as ACID.
ACID stands for Automocity,Consistency,Isolation and
Durability.
| Is This Answer Correct ? | 2 Yes | 0 No |
Post New Answer View All Answers
What do you understand by physical_only option in dbcc checkdb?
What are the types of stored procedures in an sql server?
you added a row to a view, but the row is not shown on the view. Explain how this can happen, and how you can remedy the situation
What is sub query and its properties?
Is it possible in sql table to have more than one foreign key?
Can you explain different types of locks in sql server?
What does REVERT do in SQL Server 2005?
What does it mean to manipulate data?
What is service broker? : sql server database administration
On a windows server 2003 active – passive failover cluster, how do you find the node which is active?
Explain where clause?
Can you name some of the dml commands in sql?
What are triggers? How do you invoke a trigger on demand?
What does it mean to normalize data?
What is difference between temp table and cte?