Database Management System MCQs with Answers
Practice important Database Management System MCQs with answers and explanations.
Multiple Choice Questions
Q701: What is the main concern of concurrency control (CC) in a database system?
- A: Maintaining consistency during concurrent access
- B: Reducing transaction execution time
- C: Increasing the number of transactions
- D: Improving hardware performance
View Answer
A
Q702: Which problem is illustrated by transactions where one operates on many records while another modifies some of them, affecting the result of the first?
- A: Uncommitted Update Problem
- B: Inconsistent Analysis
- C: Deadlock
- D: Serializability Problem
View Answer
B
Q703: In a serial schedule, how are transactions executed?
- A: One after another, in a sequential order
- B: Simultaneously, with interleaved operations
- C: Based on their priority level
- D: According to user input order
View Answer
A
Q704: Which type of schedule is preferred for efficient execution but may generate concurrency problems if not controlled properly?
- A: Serial Schedule
- B: Interleaved Schedule
- C: Static Schedule
- D: Batch Schedule
View Answer
B
Q705: In which situation does serializability ensure the consistency of the database?
- A: When transactions are executed in a serial order
- B: When transactions are executed in an interleaved manner
- C: When conflicting operations are in a serial order
- D: When non-conflicting operations are interleaved
View Answer
C
Q706: What is the purpose of locking in concurrency control?
- A: To ensure that only one transaction can perform an operation on an object at a time
- B: To increase the speed of transaction processing
- C: To allow multiple transactions to read the same object simultaneously
- D: To reduce the number of transactions in the system
View Answer
A
Q707: Which type of lock allows multiple transactions to read an object at the same time?
- A: Read lock
- B: Write lock
- C: Exclusive lock
- D: Shared lock
View Answer
A
Q708: If a transaction holds a write lock on an object, which type of lock request will not be granted?
- A: Read lock
- B: Write lock
- C: Shared lock
- D: None of the above
View Answer
B
Q709: What problem is addressed by serializability in concurrent transactions?
- A: Conflicting operations are handled to ensure consistency
- B: Non-conflicting operations are interleaved
- C: Transaction execution time is minimized
- D: Database hardware is optimized
View Answer
A
Q710: What happens when a transaction with a write lock on an object is active, and another transaction requests a read lock on the same object?
- A: The read lock is granted
- B: The write lock is downgraded to a read lock
- C: The read lock request is denied
- D: The read lock request is ignored
View Answer
C