Database Management System MCQs with Answers
Practice important Database Management System MCQs with answers and explanations.
Multiple Choice Questions
Q681: What is the primary function of a waits-for graph in deadlock detection?
- A: To track the progress of transactions
- B: To identify deadlock cycles
- C: To record the number of transactions
- D: To monitor transaction throughput
View Answer
B
Q682: Fill in the blank: In a DBMS, a transaction is seen as a series of _____, which can include reads and writes of database objects.
- A: Operations
- B: Transactions
- C: Commands
- D: Actions
View Answer
D
Q683: Fill in the blank: A schedule that guarantees the effect of executing transactions serially is known as a _____ schedule.
- A: Serializable
- B: Concurrent
- C: Parallel
- D: Transactional
View Answer
A
Q684: What does the Incremental Log with Deferred Updates approach involve?
- A: Immediate updates to database buffers
- B: Log file entries for write operations are immediate
- C: Deferred updates until commit is executed
- D: Immediate log file entries for all operations
View Answer
C
Q685: What is a checkpoint in the context of database recovery?
- A: A record of transactions to be redone
- B: A record marking the start of a transaction
- C: A milestone that guarantees prior commits are reflected in the database
- D: A point where database buffers are refreshed
View Answer
A
Q686: What type of log file entry is used in the Incremental Log with Immediate Updates approach?
- A:
- B:
- C:
- D:
View Answer
B
Q687: When a crash occurs, which transactions are redone according to the deferred update approach?
- A: Transactions with begin and commit entries
- B: Transactions with begin and abort entries
- C: Transactions with only begin entries
- D: All transactions regardless of their status
View Answer
A
Q688: In the event of a system crash, how does the recovery manager handle transactions with only a begin entry and no commit or abort?
- A: The transactions are redone
- B: The transactions are ignored
- C: The transactions are committed
- D: The transactions are canceled
View Answer
B
Q689: Fill in the blank: The deferred updates approach involves placing an entry in the log file only for a _______ operation.
- A: read
- B: write
- C: delete
- D: update
View Answer
B
Q690: What problem occurs when multiple transactions update the same object concurrently without proper control?
- A: Lost Update Problem
- B: Uncommitted Update Problem
- C: Inconsistent Analysis Problem
- D: Deadlock Problem
View Answer
A