Which property of a DBMS ensures that all operations within a transaction are completed successfully, or none of them are executed at all? MCQ with Answer and Explanation

Question

Which property of a DBMS ensures that all operations within a transaction are completed successfully, or none of them are executed at all?

A. Durability

B. Consistency

C. Isolation

D. Atomicity

Answer: Option D

Solution (By JKExamLibrary)

Atomicity follows the 'all-or-nothing' rule, ensuring that a transaction is either fully committed or completely rolled back if an error occurs.

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

Request complete Subject PDF

Discuss this Question (0)

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

Practice More Database Management System (DBMS) Questions

Question #1

Share Report

In SQL, what does the wildcard '%' match when used with LIKE?

A. Any single character

B. Only digits

C. A specific character

D. Any string of zero or more characters

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option D

Explanation:
'%' matches any sequence of zero or more characters, while '_' matches a single character.

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

Question #2

Share Report

What is the full form of RDBMS?

A. Random Data Backup Management System

B. Relational Data Binary Management System

C. Real-time Database Management Software

D. Relational Database Management System

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option D

Explanation:
RDBMS stands for Relational Database Management System.

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

Question #3

Share Report

In SQL, which operator is used to combine two conditions and returns true if both are true?

A. NOT

B. XOR

C. AND

D. OR

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option C

Explanation:
The AND operator returns true only if both conditions are true.

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

Explore All Database Management System (DBMS) MCQs