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

Which property of a DBMS ensures that all operations within a transaction are completed successfully, or none of them are executed at all?
A. Consistency
B. Isolation
C. Durability
D. Atomicity
Answer: Option D
Solution (By JKSSB Mock Tests)
Atomicity follows the 'all-or-nothing' rule, ensuring that a transaction is either fully committed or completely rolled back if an error occurs.

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 purpose of the SQL 'DEFAULT' constraint?
A. To enforce uniqueness
B. To provide a default value for a column when no value is supplied
C. To set a foreign key
D. To define a primary key

Correct Answer: Option B


Explanation:
DEFAULT assigns a default value to a column if an INSERT statement does not specify a value.

This question belongs to: Computer Database Management System (DBMS)
Question #2
What type of anomaly occurs when deleting a row inadvertently destroys other independent, valuable historical facts from the database?
A. Selection Anomaly
B. Insertion Anomaly
C. Projection Anomaly
D. Deletion Anomaly

Correct Answer: Option D


Explanation:
A Deletion Anomaly occurs when the deletion of a specific data record unintentionally deletes other distinct, unrelated information that should have been preserved.

This question belongs to: Computer Database Management System (DBMS)
Question #3
Information is:
A. Raw facts and figures
B. Processed and meaningful form of data
C. Programming code
D. Hardware component

Correct Answer: Option B


Explanation:
Information is data that has been organized and processed to provide context and meaning.

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