Practice Library
All MCQs
Browse exam-wise, subject-wise, and country-wise MCQs with explanations.
Choose an option to check your answer.
Correct Answer: A. committed changes survive crashes and system failures
Explanation:
This statement is correct because durability means that committed changes survive crashes and system failures.
Choose an option to check your answer.
Correct Answer: D. committed changes survive crashes and system failures
Explanation:
durability is used in Advanced DBMS because committed changes survive crashes and system failures.
Choose an option to check your answer.
Correct Answer: C. committed changes survive crashes and system failures
Explanation:
The correct answer explains durability in the context of Transactions.
Choose an option to check your answer.
Correct Answer: C. concurrent transactions should not interfere in a way that violates correctness
Explanation:
This statement is correct because isolation means that concurrent transactions should not interfere in a way that violates correctness.
Choose an option to check your answer.
Correct Answer: B. concurrent transactions should not interfere in a way that violates correctness
Explanation:
isolation is used in Advanced DBMS because concurrent transactions should not interfere in a way that violates correctness.
Choose an option to check your answer.
Correct Answer: A. concurrent transactions should not interfere in a way that violates correctness
Explanation:
The correct answer explains isolation in the context of Transactions.
Choose an option to check your answer.
Correct Answer: C. a transaction moves the database from one valid state to another valid state
Explanation:
This statement is correct because consistency means that a transaction moves the database from one valid state to another valid state.
Choose an option to check your answer.
Correct Answer: C. a transaction moves the database from one valid state to another valid state
Explanation:
consistency is used in Advanced DBMS because a transaction moves the database from one valid state to another valid state.
Choose an option to check your answer.
Correct Answer: D. a transaction moves the database from one valid state to another valid state
Explanation:
The correct answer explains consistency in the context of Transactions.
Choose an option to check your answer.
Correct Answer: B. a transaction is treated as all-or-nothing
Explanation:
This statement is correct because atomicity means that a transaction is treated as all-or-nothing.
Choose an option to check your answer.
Correct Answer: D. a transaction is treated as all-or-nothing
Explanation:
atomicity is used in Advanced DBMS because a transaction is treated as all-or-nothing.
Choose an option to check your answer.
Correct Answer: D. a transaction is treated as all-or-nothing
Explanation:
The correct answer explains atomicity in the context of Transactions.
