The concept that prevents concurrent transactions from interfering with each other and creating data inconsistencies is known as what? MCQ with Answer and Explanation

The concept that prevents concurrent transactions from interfering with each other and creating data inconsistencies is known as what?
A. Consistency
B. Isolation
C. Atomicity
D. Durability
Answer: Option B
Solution (By JKSSB Mock Tests)
Isolation ensures that the execution of concurrent transactions does not interfere with one another, making them appear as if they are executing sequentially.

Discuss this Question (0)

No comments yet. Be the first to start the discussion!

Practice More Database Management System (DBMS) Questions

Question #1
What is the alternative mathematical term used for a 'Table' in a relational database model?
A. Tuple
B. Relation
C. Attribute
D. Domain

Correct Answer: Option B


Explanation:
In relational model terminology introduced by E.F. Codd, a table is formally referred to as a relation.

This question belongs to: Computer Database Management System (DBMS)
Question #2
Which of the following is not an aggregate function in SQL?
A. AVG
B. MAX
C. SUM
D. DESC

Correct Answer: Option D


Explanation:
DESC is a keyword for sorting order, not an aggregate function.

This question belongs to: Computer Database Management System (DBMS)
Question #3
What does DDL stand for in SQL?
A. Data Definition Language
B. Data Description Language
C. Dynamic Data Link
D. Data Manipulation Language

Correct Answer: Option A


Explanation:
DDL (Data Definition Language) includes commands like CREATE, ALTER, DROP for defining database structures.

This question belongs to: Computer Database Management System (DBMS)