DFC20283 CHAPTER 5

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