Database Management System MCQs with Answers
Practice important Database Management System MCQs with answers and explanations.
Multiple Choice Questions
Q711: What are the two types of locks mentioned in concurrency control?
- A: Read lock and Write lock
- B: Exclusive lock and Shared lock
- C: Temporary lock and Permanent lock
- D: Basic lock and Advanced lock
View Answer
A
Q712: Fill in the blank: A _______ schedule has operations of different transactions interleaved with each other, which provides more efficient execution.
- A: serial
- B: parallel
- C: interleaved
- D: concurrent
View Answer
C
Q713: Which of the following best describes optimistic locking?
- A: The system locks data until the transaction completes
- B: The system locks data temporarily during the transaction
- C: The system does not lock data and checks for changes later
- D: The system immediately releases all locks
View Answer
A
Q714: What is the main goal of locking in database systems?
- A: To ensure transactions are isolated from each other
- B: To prevent transactions from accessing data
- C: To optimize query execution speed
- D: To increase system performance
View Answer
B
Q715: In which phase does a transaction only release locks in the Two Phase Locking approach?
- A: Growing phase
- B: Shrinking phase
- C: Acquiring phase
- D: Committing phase
View Answer
B
Q716: What occurs during a deadlock in a database system?
- A: Transactions complete successfully without any issues
- B: Transactions are blocked indefinitely, waiting for each other to release locks
- C: Transactions are rolled back and restarted automatically
- D: Transactions are ignored until manual intervention is performed
View Answer
B
Q717: What is the purpose of the wait-for graph in deadlock handling?
- A: It detects the current status of transactions
- B: It identifies the resources currently being used
- C: It helps to visualize and detect deadlocks
- D: It prevents deadlocks from occurring
View Answer
A
Q718: The timestamping method in database systems is used to:
- A: Prevent all transactions from seeing uncommitted changes
- B: Ensure transactions are executed in a specific order without locks
- C: Lock data to prevent other transactions from accessing it
- D: Force all transactions to complete before others can start
View Answer
B
Q719: Which type of lock ensures that no other transaction can access the locked data?
- A: Shared lock
- B: Update lock
- C: Exclusive lock
- D: Temporary lock
View Answer
C
Q720: Fill in the blank: A transaction with an isolation level of __________ does not result in any locks on the data read by the transaction.
- A: read committed
- B: read uncommitted
- C: repeatable read
- D: serializable
View Answer
B