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

What is database replication?

574


what is normalization? : Sql server database administration

529


Difference between Inner vs outer joins?

531


Explain how to send email from sql database?

559


Why transaction is important?

563






Can you always create a cache of a report?

115


What are the types of lock supported by ?

612


How many categories of data types used by sql server?

593


How sql server executes a statement with nested subqueries?

507


What are the different types of indexes?

610


A trigger can reference objects outside the current database? State true or false.

550


What are the difficulties faced in cube development? : sql server analysis services, ssas

605


What is normalization? Explain different forms of normalization?

534


What is the purpose of update statistics and scope_identity() function?

597


Can we add a cpu to sql server?

517