Interested to Buy Any Domain ? << Click Here >> for more details...
Answer Posted / sagar
Atomicity: is an all-or-none proposition.
Consistency: guarantees that a transaction never leaves your
database in a half-finished state.
Isolation: keeps transactions separated from each other
until they’re finished.
Durability: guarantees that the database will keep track of
pending changes in such a way that the server can recover
from an abnormal termination.
Above four rules are very important for any developers
dealing with databases.
| Is This Answer Correct ? | 2 Yes | 0 No |
Post New Answer View All Answers
What do you mean by Correlated subquery in database?
How to recreate the index on a firebird table?
What is file manager?
Compare a hierarchical and network database model?
Differentiate table scan from index scan.
Explain the components of rdbms?
What do you understand by data redundancy?
How to use multiple database server in back end ?
Define sub-query.
What is Normalization and its different forms?
describe and contrast a trigger and a procedure.
explain about the critical recovery scenario you had experienced
What are the three levels of data abstraction?
What is authorization and integrity manager?
I have 2 tables with 1 million rows each. I have updated 1 row in first and 1 million update on second table. Now I commit both the updates. Which one will commit fast and Why?
