What is a transaction and what are ACID properties?

Answer Posted / mobin sathupally

A transaction is a logical unit of work in which, all the
steps must be performed or none.A transaction follows four
properties(rules).These four properties are known as ACID.
ACID stands for Automocity,Consistency,Isolation and
Durability.

Is This Answer Correct ?    2 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is difference between views and tables?

639


What happens if ntwdblib.dll is missing on your machine?

865


Find columns used in stored procedure?

704


What are the functions in sql server?

707


Do you know what is bit data type and whats the information that can be stored inside a bit column?

722






What are scalar functions in sql?

813


hi, the following are the outputs of sp_spaceused and sp_tempdbspace sp_spaceused ------------ database size unallocated size tempdb 77752.95 MB 28026.99 MB sp_tempdbspace ------------- database size spaceused tempdb 77752.945312 1.007812 the unused space in sp_spaceused is nearly 28 Gb and in sp_tempdbspace is nearly 76 Gb cany any one explain about this output and why its giving different results.

2677


Write down the syntax and an example for create, rename and delete index?

723


What is the impact on other user sessions when creating indexes?

713


Tell me what is a linked server?

767


Do you know spatial data types - geometry and geography in sql server 2008?

768


What is the difference between index seek vs. Index scan?

771


What is a database table?

697


System requirements for sql server 2005 express edition?

729


what are user defined datatypes? : Sql server database administration

720