Database Management System MCQs with Answers
Practice important Database Management System MCQs with answers and explanations.
Multiple Choice Questions
Q691: How does the Recovery Manager handle transactions with a commit entry but with already applied changes during a crash?
- A: The changes are redone
- B: The changes are ignored
- C: The changes are reversed
- D: The changes are merged
View Answer
A
Q692: Which of the following is NOT a problem due to concurrent access?
- A: Lost Update Problem
- B: Uncommitted Update Problem
- C: Inconsistent Analysis Problem
- D: No Update Problem
View Answer
D
Q693: What should a log file entry look like in the Immediate Updates approach when a transaction is aborted?
- A:
- B:
- C:
- D:
View Answer
A
Q694: In the Lost Update Problem, what value is overwritten by the final write operation?
- A: The value written by the first transaction
- B: The initial value of the object
- C: The value written by the second transaction
- D: The final value of the object
View Answer
B
Q695: Fill in the blank: In the Incremental Log with Deferred Updates approach, log entries are made for _______ operations only.
- A: read
- B: write
- C: commit
- D: begin
View Answer
B
Q696: How are transactions with a begin and abort entry treated during recovery?
- A: They are redone
- B: They are ignored
- C: They are committed
- D: They are reversed
View Answer
B
Q697: Fill in the blank: The primary goal of concurrency control is to maintain the _______ of the database in the face of concurrent access.
- A: security
- B: consistency
- C: integrity
- D: availability
View Answer
B
Q698: What action is taken when a transaction with a begin entry and no commit or abort entry is detected during recovery?
- A: It is redone
- B: It is ignored
- C: It is reversed
- D: It is committed
View Answer
B
Q699: What is a key characteristic of the Immediate Updates approach compared to Deferred Updates?
- A: Immediate update of database buffers
- B: Deferred logging of write operations
- C: Delayed database updates
- D: Immediate log entries for all operations
View Answer
A
Q700: What problem occurs when a transaction updates an object and another transaction reads this updated value before the first transaction is aborted?
- A: Uncommitted Update Problem
- B: Inconsistent Analysis
- C: Deadlock
- D: Snapshot Isolation
View Answer
A