What is a transaction and what are ACID properties?
Answers were Sorted based on User's Feedback
Answer / srivas
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 ? | 8 Yes | 0 No |
Answer / 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 |
Answer / rahul
transaction is only the reading or writing or both reading
and writing in a database. when we are reading from a
database that is transaction where the database is not
changing. in writing into database the database values can
be changed. we can do both reading and writing in a database.
to do these operations the database must have the acid
properties.
| Is This Answer Correct ? | 0 Yes | 0 No |
What are the default system databases in sql server 2000?
What is indexing in sql server with example?
What do you understand by intent locks?
syntax and example for bitmap index in sql???
what is the maximum size of a row in sql server 2000 and 2005
how to improve the speed of SQL database server and how to avoid dead lock?
what are batch in sql server?
Explain subquery and state its properties?
When a primary key constraint is included in a table, what other constraints does this imply?
how do you implement one-to-one, one-to-many and many-to-many relationships while designing tables? : Sql server database administration
How to create stored procedures with parameters in ms sql server?
When do you think a developer should use sql server-based cursors?
Oracle (3253)
SQL Server (4518)
MS Access (429)
MySQL (1402)
Postgre (483)
Sybase (267)
DB Architecture (141)
DB Administration (291)
DB Development (113)
SQL PLSQL (3330)
MongoDB (502)
IBM Informix (50)
Neo4j (82)
InfluxDB (0)
Apache CouchDB (44)
Firebird (5)
Database Management (1411)
Databases AllOther (288)