What is a transaction and what are ACID properties?

Answer Posted / swapna

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 ?    188 Yes 18 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

When would you use sql joins?

524


What are ddl (data definition language) statements for tables in ms sql server?

538


what is the difference between count(*) and count(1) ?

627


What happens when converting big values to numeric data types?

565


To automatically record the time on which the data was modified in a table, which data type should you choose for the column?

533






Is t sql the same as sql server?

513


What are temporal tables in sql server 2016?

476


What were the latest updates to SQL Azure service?

92


Can an entity have two primary keys?

522


Define inner join? Explain with an example?

511


Explain Reporting Life Cycle?

90


What are three ways you can use an identity value inside a trigger? Why would you prefer one way over another?

547


what are the different ways of moving data/databases between servers and databases in sql server? : Sql server database administration

509


Is sql server a database?

531


how to create a scrollable cursor with the scroll option? : Sql server database administration

607