Friday, January 14, 2022

DBMS Solved MCQ - Atomicity property required for 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 ensure the completeness of transactions in DBMS?

DBMS MCQ - Atomicity - first of the ACID properties a transaction should possess in RDBMS

< Previous                      

Next >

 

1. To ensure integrity of the data, a database system should ensure transactions to possess certain properties. The property that makes sure that “either all instructions executed successfully or none of them are” is called

a) Atomicity

b) Consistency

c) Isolation

d) Durability

Answer: (a) Atomicity

While executing a transaction, the most desirable property is to execute all the instructions of the given transaction or execute none (if executed few, roll them back). This property helps to avoid inconsistencies caused by an incomplete transaction. Atomicity is the property which ensures this.

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:


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

Featured Content

Multiple choice questions in Natural Language Processing Home

MCQ in Natural Language Processing, Quiz questions with answers in NLP, Top interview questions in NLP with answers Multiple Choice Que...

All time most popular contents

MageNet Ad

data recovery