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
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 |
What is built-in function?
Difference between report and query parameter. Why do we need different type of parameter?
What is explicit mode in sql server?
What is the process of normalising?
Why can there be only one clustered index and not more than one?
What is the use of “join” in sql server?
How to Rebuild Master database in sql server 2005.
what operator performs pattern matching?
What is implicit mode in sql server?
What do you understand by the denormalisation?
What is the maximum size of column in sql server?
What is normalization and its types?
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)