Interested to Buy Any Domain ? << Click Here >> for more details...
Answer Posted / pallis
Atomicity
The entire sequence of actions must be either completed or aborted. The transaction cannot be partially successful.
Consistency
The transaction takes the resources from one consistent state to another.
Isolation
A transaction's effect is not visible to other transactions until the transaction is committed.
Durability
Changes made by the committed transaction are permanent and must survive system failure.
| Is This Answer Correct ? | 3 Yes | 0 No |
Post New Answer View All Answers
There are 100 datafiles, numbered from 1 to 100. File number 10 is deleted and it has 500 MB of data. The database is working in archive log mode. How can be the database recovered ? While doing recovery the archive logs applied are from nos 1 to 100, but 50 gets corrupted. What do we do? Can we proceed further? If so how?
What is the best database for big data?
Enlist ways to efficiently code transactions.
What is the e-r model?
What is dbms and its advantages?
Can you explain the select into statement?
What are the disadvantages of a query?
What are the 4 main objects of a database?
What do you mean by checkpoints in dbms?
How is the pattern matching done in the sql?
Can you explain the 'between' clause?
Explain the Logical Schema of Database
What is the full meaning of dbms?
What is the meaning of flat file database?
What is 2nf in database?
