What is a transaction and what are ACID properties?
Answer Posted / srivas
A transaction is a logical unit of work in which, all the
steps must be performed or none. ACID stands for Atomicity,
Consistency, Isolation, Durability. These are the properties
of a transaction.
| Is This Answer Correct ? | 8 Yes | 0 No |
Post New Answer View All Answers
Can you tell me some of the common replication dmv's and their use? : sql server replication
What is pivot and unpivot?
What are the benefits of normalization?
What is difference between clustered index and non clustered index?
What is isnull() operator?
Can primary key be null?
What are orphan records?
Is it possible to update the views? If yes, how, if not, why?
Can we check locks in database? If so, how can we do this lock check?
Difference between 2NF &3NF ?
How many replicas are maintained for each sql azure db?
What is the difference between dropping a database and taking a database offline?
wat wil hapn if we give the both read and deny read permission to user?
Where can you add custom error messages to sql server?
Can the query output be sorted by multiple columns in ms sql server?