Database Management System MCQs with Answers
Practice important Database Management System MCQs with answers and explanations.
Chapter: 45
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
Correct Answer:
C
Chapter: 45
Q722:
Which of the following is NOT a type of lock classification?
A. Shared lock
B. Update lock
C. Exclusive lock
D. Temporary lock
Correct Answer:
D
Chapter: 45
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
Correct Answer:
B
Chapter: 45
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
Correct Answer:
A
Chapter: 45
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
Correct Answer:
C
Chapter: 45
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
Correct Answer:
B
Chapter: 45
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
Correct Answer:
B