Interested to Buy Any Domain ? << Click Here >> for more details...
wt is mean by acid property? i know it is
atomocity,consistency,isolation and durabulaty but wt is
these mean and wt actions it's perform
- 1 Answers
- 8863 Views
- Idea, I also Faced
- E-Mail Answers
Answer / praveen
Transaction must be Atomic (it is one unit of work and does
not dependent on previous and following transactions)
Consistent (data is either committed or roll back, no
“in-between” case where something has been updated and
something hasn’t)
Isolated (no transaction sees the intermediate results of
the current transaction)
Durable (the values persist if the data had been committed
even if the system crashes right after).
| Is This Answer Correct ? | 4 Yes | 1 No |
Do you know how to make remote connection in database?
What is the difference between having and where clause?
How to get max 100 values from sql server
How to encrypt data between dialogs?
Tell me what is the difference between locking and multi-versioning?
Explain different types of locks in sql server.
What is the difference between sql server 2000 object owner and sql server 2005 schema? : sql server database administration
How to apply cascading referential integrity in place of triggers?
What is a transaction and what are ACID properties?
14 Answers Config Systems, IBM, TCS, Virtusa,
Can you explain what are commit and rollback in sql?
How to create nested stored procedure?
Explain the difference between functions and stored procedures in sql server?
-
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)
