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
Which of the following is an example of a NoSQL database?
A. MySQL
B. MongoDB
C. Oracle
D. PostgreSQL

Correct Answer: Option B


Explanation:
MongoDB is a document-oriented NoSQL database. PostgreSQL, MySQL, and Oracle are RDBMS.

This question belongs to: Computer Database Management System (DBMS)
Question #2
What is a database instance?
A. The state of a database at a particular moment in time
B. The schema definition
C. A backup
D. A query result

Correct Answer: Option A


Explanation:
A database instance refers to the data stored in the database at a specific time, as opposed to the schema (structure).

This question belongs to: Computer Database Management System (DBMS)
Question #3
Which concept represents a temporary workspace in memory used by database engines to fetch, manipulate, and navigate through query rows one at a time?
A. View
B. Trigger
C. Cursor
D. Index

Correct Answer: Option C


Explanation:
A Cursor is a database control structure that allows an application or script to traverse over the records of a query result set row by row.

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