What is a transaction and what are ACID properties?
Answer Posted / piyush
transaction is a set of operation or activities which are
executed in a logical unit of work which is know as transaction.
ACID
A-Atomicity
C-Consistency
I-Isolation
D-Durability
| Is This Answer Correct ? | 28 Yes | 8 No |
Post New Answer View All Answers
What are the differences between substr and charindex in sql server.
How to get the definition of a stored procedure back?
How to retrieve field values using mssql_result()?
How can we call UDF(User Define Function) using C# code in ASP.net ?
Are null values the same as that of zero or a blank space?
Explain nested join?
Is it true, that there is no difference between a rule and a check constraint?
What are dml triggers and types of dml triggers?
What do you understand by user-defined function in the sql server and explain the steps to create and execute a user-defined function in the sql server?
What are the new data types are introduced in sql 2000?
What is an indexed view?
Explain features and concepts of analysis services?
What are the new security features added in sql server 2012? : sql server security
How to populate a table in sql server?
explain different types of cursors? : Sql server database administration