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
What is difference between views and tables?
What happens if ntwdblib.dll is missing on your machine?
Find columns used in stored procedure?
What are the functions in sql server?
Do you know what is bit data type and whats the information that can be stored inside a bit column?
What are scalar functions in sql?
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.
Write down the syntax and an example for create, rename and delete index?
What is the impact on other user sessions when creating indexes?
Tell me what is a linked server?
Do you know spatial data types - geometry and geography in sql server 2008?
What is the difference between index seek vs. Index scan?
What is a database table?
System requirements for sql server 2005 express edition?
what are user defined datatypes? : Sql server database administration