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
How do you debug a procedure in sql server?
What are the Advantages of using CTE in sql server?
What is the difference between char and varchar2 datatype in sql?
What is recursion? Is it possible for a stored procedure to call itself or recursive stored procedure? How many levels of sp nesting are possible?
How many replicas are maintained for each sql azure db?
What is scd (slowly changing dimension)? : sql server analysis services, ssas
What is a performance monitor?
Explain what are the authentication modes in sql server?
How to verify a user name with sqlcmd tool?
How to select all columns of all rows from a table with a select statement in ms sql server?
What is the use of @@spid?
What is temporal data type?
Can we use where clause in union?
What are the restrictions applicable while creating views? : SQL Server Architecture
Define Business Edition in SQL Azure?