Which property of ACID ensures that a transaction is treated as a single unit that either fully succeeds or fully fails? MCQ with Answer and Explanation

Which property of ACID ensures that a transaction is treated as a single unit that either fully succeeds or fully fails?
A. Consistency
B. Isolation
C. Atomicity
D. Durability
Answer: Option C
Solution (By JKSSB Mock Tests)
Atomicity ensures that all operations within a transaction are completed successfully; otherwise, the transaction is aborted and all changes are rolled back.

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 ensures data integrity in RDBMS?
A. Constraints like primary key, foreign key
B. No validation rules
C. Random data entry
D. User input without checks

Correct Answer: Option A


Explanation:
Integrity constraints such as keys enforce rules for valid data.

This question belongs to: Computer Database Management System (DBMS)
Question #2
What is a synonym in database terms?
A. An alias for a table or view
B. A type of index
C. A data type
D. A foreign key

Correct Answer: Option A


Explanation:
A synonym is an alternative name for a database object, allowing simpler references.

This question belongs to: Computer Database Management System (DBMS)
Question #3
In SQL, which statement is used to change a user's password?
A. MODIFY USER
B. UPDATE USER
C. CHANGE USER
D. ALTER USER

Correct Answer: Option D


Explanation:
ALTER USER is used in many DBMS to change user attributes, including password. The exact syntax varies by DBMS.

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