DBMS Solved MCQ - Isolation property of transactions in RDBMS

Multiple choices questions in DBMS, Transaction states in database, What are the ACID properties? Why incomplete transactions should not visible to other transactions in RDBMS? Who enforces ACID properties? What properties safeguard the integrity of data in DBMS?

DBMS MCQ - Isolation - one of the ACID properties a transaction should possess

< Previous

Next >

 

1. To ensure integrity of the data, a database system should ensure transactions to possess certain properties. The property which make sure that the partial effects of incomplete transactions should not visible to the other transactions is called

a) Atomicity

b) Consistency

c) Isolation

d) Durability

Answer: (c) Isolation Isolation property is one of ACID properties that a transaction should possess. It ensures that the changed made by a transaction should not be visible to other concurrent transactions. It means that the data used during the execution of a transaction cannot be used by a second transaction until the first one is completed. ACID properties are the desirable properties that any transaction should possess in a relational database management system. These properties help in safeguarding the integrity of the data. ACID properties should be enforced by concurrency control methodologies.

 

< Previous

Next >

************************

Related posts:

• Go to Multiple Choice Questions in DBMS home

• Go to Normalization - MCQs page

• Go to General Mixed Quiz in all topics of DBMS page

• Go to Advanced DBMS Concepts page

What are the ACID properties? 

Why incomplete transactions should not visible to other transactions in RDBMS? 

Who enforces ACID properties? 

What properties safeguard the integrity of data in DBMS?

Can we permit multiple transactions to execute in parallel?

DBMS Solved MCQ, Database management system solved mcq, transaction management system solved mcq, transaction states solved mcq, transaction mcq