Database Modeling and Design MCQs with Answers
Practice important Database Modeling and Design MCQs with answers and explanations.
Multiple Choice Questions
Q321: What does the Durability property of a transaction guarantee?
- A: The system can recover data after a failure
- B: The transaction is isolated from other transactions
- C: The database will remain consistent
- D: The transaction will not be rolled back
View Answer
A
Q322: If a transaction violates a database constraint, what property is compromised?
- A: Durability
- B: Isolation
- C: Consistency
- D: Atomicity
View Answer
C
Q323: Which of the following scenarios demonstrates the Consistency property?
- A: Updating a record without any data validation
- B: Performing operations that affect multiple tables simultaneously
- C: Ensuring no constraint violations during a transaction
- D: Executing transactions in isolation
View Answer
C
Q324: What should happen to a transaction if a system failure occurs midway?
- A: The system should restart the transaction
- B: The transaction should be committed partially
- C: The system should rollback the transaction to its initial state
- D: The transaction should be executed manually
View Answer
C
Q325: Fill in the blank: The ________ property of transactions ensures that the database is in a consistent state before and after the transaction.
- A: Atomicity
- B: Isolation
- C: Consistency
- D: Durability
View Answer
C
Q326: Fill in the blank: A transaction's effects are permanently in place in the system even if the system fails or restarts, ensuring ________.
- A: Consistency
- B: Isolation
- C: Durability
- D: Atomicity
View Answer
C
Q327: Fill in the blank: The property that allows the system to handle simultaneous transactions as if each were the only transaction is called ________.
- A: Isolation
- B: Atomicity
- C: Consistency
- D: Durability
View Answer
A
Q328: What problem occurs when multiple transactions update the same data but one transaction's updates are overwritten?
- A: Lost Update Problem
- B: Uncommitted Data
- C: Deadlock
- D: Granularity Issue
View Answer
A
Q329: Which problem happens when one transaction reads data updated by another transaction that has not yet committed?
- A: Uncommitted Data
- B: Lost Update Problem
- C: Deadlock
- D: Granularity Issue
View Answer
A
Q330: What is the main purpose of using locks in a database system?
- A: To speed up transaction processing
- B: To ensure data consistency
- C: To reduce database size
- D: To increase query execution time
View Answer
B