NEW
Font size
WorksheetsDFC20283 CHAPTER 5
Total questions: 15
Worksheet time: 8mins
The situation where one transaction overwrites another transaction’s update is known as:
Dirty Read
Lost Update
Deadlock
Inconsistent Retrieval
A lock that allows multiple transactions to read but not update is:
Exclusive Lock
Binary Lock
Shared Lock
Update Lock
A system that collects data and processes it at a later time is referred to as:
Batch processing system
Real-time processing system
Distributed system
OLTP
A situation where transactions wait indefinitely for each other is called:
Starvation
Deadlock
Blocking
Rollback
The ACID property that ensures data remains after commit is:
Atomicity
Consistency
Isolation
Durability
A transaction reads data that has not yet been committed by another transaction. This represents:
Lost Update
Dirty Read
Deadlock
Consistent Read
A system that allows users to perform transactions interactively and updates the database continuously represents:
Batch processing system
OLTP
Real-time processing system
File processing system
A transaction follows a protocol where it acquires all locks before releasing any. This refers to:
Deadlock Prevention
Two-Phase Locking
Granularity Control
Checkpoint
A system uses transaction logs to reapply committed changes after a crash. This operation is known as:
Undo
Backup
Locking
Redo
A transaction reads the same data twice and gets different values due to another transaction’s update. This represents:
Dirty Read
Lost Update
Inconsistent Retrieval
Deadlock
Two transactions update the same record. The final value only reflects one update while the other is lost. This scenario illustrates:
Inconsistent Retrieval
Lost Update
Deadlock
Dirty Read
A transaction is updating a record while another transaction is denied access until the first finishes. This situation uses:
Exclusive Lock
Shared Lock
Binary Lock
Checkpoint
A stock trading platform requires immediate processing of transactions to ensure accurate and up-to-date data at every second. This system is best categorized as:
Batch processing system
Data warehouse system
OLTP system
Real-time processing system
A database ensures that once a transaction is committed, its changes will not be lost even after failure. This demonstrates:
Isolation
Consistency
Atomicity
Durability
Transaction T1 holds resource A and waits for B, while T2 holds B and waits for A. The system becomes stuck. This scenario represents:
Starvation
Lost Update
Dirty Read
Deadlock
