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 |
Wht is SQL Injection Attack ?
How do you fine the performance tunning?
Mention the 3 ways to get a count of the number of records in a table.
what operator performs pattern matching?
What is the datatype returned by count(*)
22 Answers 247Customer, Asian CERC,
Define normalisation?
What is the difference between login and a user?
13 Answers CTS, TCS,
How many categories of data types used by sql server?
What is INTVAL( )and where we use Plz any body help me
two tables with table name ship(name,year) and battle (name,year),how to find the latest added year in the table ship
can a database be shrunk with users active? : Sql server administration
What is the diff between Dynamic queries and static queries
1 Answers CGG, ICS Integrated Computer Solutions,
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)