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 |
How do database indexes work?
How to provide Security for package?
Let us say the SQL Server crashed and you are rebuilding the databases including the master database what procedure to you follow?
What are the recovery models in sql server 2000?
What are the steps you will take to improve the performance of a poor performing query?
What is the differecne between equi-join and inner-join and natural join..Is there any difference or all are same?
What program is used to store the data source file?
What are partitioned views and distributed partitioned views?
What are indexes in sql?
Can group functions be used in the order by clause in ms sql server?
What are the differences between DDL, DML and DCL in SQL?
0 Answers ABB, Aspire, Infogain,
Does hive support indexing?
Oracle (3259)
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)