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


Please Help Members By Posting Answers For Below Questions

How each E-R model constructs can be mapped to the relational model?

722


What are the restrictions that views have to follow?

725


What are the authentication modes in sql server? How can it be changed?

794


How to sort query output in descending order in ms sql server?

748


What does null mean?

756


What are the Advantages of using CTE in sql server?

773


Explain syntax for viewing, dropping and disabling triggers?

694


What are acid properties of transaction?

693


What is tablix?

136


What are the five characteristics of good data?

688


How check triggers in sql server?

673


Can a function call a stored procedure in sql server?

704


what is a schema in sql server 2005? Explain how to create a new schema in a database? : Sql server database administration

724


What is normalization? Explain different forms of normalization?

758


What is the difference between functions and scalar functions?

756