Database Management System MCQs with Answers
Practice important Database Management System MCQs with answers and explanations.
Multiple Choice Questions
Q721: In Two Phase Locking, once a transaction releases a lock, it:
- A: Must acquire additional locks
- B: Must wait for other transactions to finish
- C: Must not acquire any additional locks
- D: Might acquire more locks if needed
View Answer
C
Q722: Which of the following is NOT a type of lock classification?
- A: Shared lock
- B: Update lock
- C: Exclusive lock
- D: Temporary lock
View Answer
D
Q723: What is a cascading rollback in the context of timestamping?
- A: A rollback of a transaction that affects other transactions that have seen the data written by the aborted transaction
- B: A process to automatically commit transactions after a rollback
- C: A rollback of all transactions initiated by a single user
- D: A mechanism to update data in real-time
View Answer
B
Q724: In the context of deadlock handling, the shortest-lived transaction is often chosen as:
- A: The victim to rollback
- B: An additional lock holder
- C: A potential deadlock cause
- D: The primary transaction to resolve the issue
View Answer
A
Q725: What does a shared lock allow other transactions to do?
- A: Write to the locked data
- B: Read and write to the locked data
- C: Only read from the locked data
- D: Only update the locked data
View Answer
C
Q726: Fill in the blank: A transaction in the shrinking phase of Two Phase Locking will ____________.
- A: Acquire new locks
- B: Release existing locks
- C: Change the data it has locked
- D: Read data without locking it
View Answer
B
Q727: Which of the following approaches to deadlock handling involves detecting and resolving deadlocks through a graph?
- A: Deadlock prevention
- B: Deadlock detection and resolution
- C: Deadlock avoidance
- D: Deadlock isolation
View Answer
B