Latest RDBMS Aptitude Question SOLUTION: Sunil is working on a database management system. He wants to program transactions such that a transaction is completed only if all the database operations are completed and commit

• Placement Papers
• /
• RDBMS
• /
• Programming
• /
• Database

RDBMS Question Papers:

(#M40153957) RDBMS Programming question Keep an EYE

Sunil is working on a database management system. He wants to program transactions such that a transaction is completed only if all the database operations are completed and commited, otherwise the transaction is aborted and rolled back. Which of the following database characteristics is he trying to implement?

o Atomicity
o Consistency
o Isolation
o Durability

Asked In RDBMS swastika (8 years ago)

Unsolved Read Solution (4)

Is this Puzzle helpful?   (19)   (16) Submit Your Solution Database

Read Solution (4) :

jai gour  (8 years ago)

ATOMICITY
because In a transaction involving two or more discrete pieces of information, either all of the states are committed or none are.

Is this solution Helpfull? Yes (5) | No   

Ravi Singh  (8 years ago)

Atomicity - says either everything should be done or none should be done .
consistency - evything should be fine . no wrong value should exist in database , taking care of atomicity isolation and durability automatically make it happen .
isolation - transition should be executed as they are alone .
durability - after commit the changes must be preserved .

definitely . it's atomicity which he want to get . so answer a .

Is this solution Helpfull? Yes (4) | No   

swastika  (8 years ago)

Thankyou Mr. Jai !!!

Is this solution Helpfull? Yes (3) | No   

shweta shivaji lokhande.  (7 years ago)

Atomicity. Because atomicity means either all or none of the operation should execute.........

Is this solution Helpfull? Yes (1) | No   

Please Login to Read Solution.