Database Modeling and Design MCQs with Answers
Practice important Database Modeling and Design MCQs with answers and explanations.
Multiple Choice Questions
Q331: What does a read lock do in a multi-user database system?
- A: Prevents other users from reading the data
- B: Allows other users to read the data but prevents writing
- C: Prevents any access to the data
- D: Allows only one user to update the data
View Answer
B
Q332: Which level of lock involves locking an entire table?
- A: Database Lock
- B: File Lock
- C: Table Lock
- D: Row Lock
View Answer
C
Q333: What level of lock is the most commonly used and supported by major database vendors?
- A: Column Lock
- B: Row Lock
- C: Table Lock
- D: File Lock
View Answer
B
Q334: Which type of lock prevents other transactions from accessing the data until the current transaction is completed?
- A: Shared Lock
- B: Exclusive Lock
- C: Read Lock
- D: Write Lock
View Answer
B
Q335: Fill in the blank: The problem of ________ occurs when a transaction reads data that has been updated by another transaction which has not yet committed.
- A: Uncommitted Data
- B: Lost Update
- C: Deadlock
- D: Granularity Issue
View Answer
A
Q336: Fill in the blank: The level of lock where only a particular column or multiple columns are locked is called ________.
- A: Row Lock
- B: File Lock
- C: Column Lock
- D: Table Lock
View Answer
C
Q337: Fill in the blank: A ________ Lock allows multiple users to read the same data simultaneously but prevents any updates until the lock is released.
- A: Shared
- B: Exclusive
- C: Read
- D: Write
View Answer
A
Q338: Fill in the blank: To prevent dirty data in concurrent transactions, database systems use ________.
- A: Locks
- B: Indexes
- C: Caches
- D: Cursors
View Answer
A
Q339: Which of the following is NOT a level of lock granularity in a database?
- A: Column Lock
- B: Row Lock
- C: Transaction Lock
- D: Table Lock
View Answer
C
Q340: What is one method for detecting deadlocks in a database system?
- A: Use a priority-based locking system
- B: Increase the number of locks allowed
- C: Set a lock wait time limit
- D: Allow all transactions to execute concurrently
View Answer
C