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
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. |
- 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