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 is the role of database server in database management system?
How can I access my database remotely?
What are the different types of modeling?
What are the types of database?
Explain entity, entity type, and entity set in dbms?
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?
What are the characteristics of database management system?
Explain degree of a relation?
What is database users in dbms?
How do you copy a database?
What is implicit cursor in dbms?
What do you understand by the view and mention the steps to create, update and drop a view?
Explain issues for database performance.
IF Statements BLOCK 1 . IF a >= b THEN do_this …..; ELSE do_that….; END IF BLOCK 2 . IF a < b THEN do_that …..; ELSE do_this….; END IF; • Given any pair of non-NULL values for “a” and”b”, will Block 1 and Block 2 do the same thing? • What if either “a” or”b” (or both) is NULL?
Define weak entity set.
