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
- 8832 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 |
Explain the difference between control flow and data flow?
How to fetch the next row from a cursor with a "fetch" statement?
What is an example of a foreign key?
What is a sql join?
Explain the truncate command?
When cursors are useful?
What is difference between Triggers and store procedure?
What is de-normalization and when do you do it?
How To Find That One Week Change in My DataBase we Have Done Like We Have A database Test I Change Table,Stored Procd. Then I Find Which SP,Table We Have Edit/Change in Seven Dayes
What is the difference between delete and truncate statements?
What is difference between after and before?
What are the types of resultset?
-
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)
