Locking Protocols and Recovery Management

Which type of lock allows multiple transactions to read a data item but prevents any modifications to it?

• Exclusive Lock

• Shared Lock

• Pre-Claiming Lock

• Simplistic Lock

What is the main disadvantage of the simplistic lock protocol?

• It prevents deadlocks.

• It uses multiple types of locks.

• It limits concurrency and can cause bottlenecks.

• It does not ensure data consistency.

In the Two-Phase Locking protocol, what is the first phase called?

• Acquiring Phase

• Expanding Phase

• Growing Phase

• Releasing Phase

Which locking protocol ensures that a transaction holds all its exclusive locks until it commits?

• Simplistic Lock Protocol

• Pre-Claiming Lock Protocol

• Strict Two-Phase Locking

• Shared Lock Protocol

What is a key disadvantage of the Pre-Claiming Lock Protocol?

• It can lead to deadlocks.

• It reduces concurrency.

• It increases transaction speed.

• It prevents cascading aborts.

What type of lock must a transaction acquire to update a data item?

• Shared Lock

• Exclusive Lock

• Read-Only Lock

• Phantom Lock

How does the Strict Two-Phase Locking protocol prevent cascading aborts?

• By acquiring all locks upfront

• By releasing shared locks after the growing phase

• By holding exclusive locks until the transaction commits

• By using only shared locks throughout the transaction

What is the main purpose of database recovery management?

• To speed up data retrieval.

• To restore the database to a consistent state after a failure.

• To prevent data modification.

• To optimize query execution.

Which recovery method involves creating periodic backups to restore data in case of failure?

• Log-Based Recovery

• Checkpointing

• Backup and Restore

• Shadow Paging

What does the rollback operation do in recovery management?

• Applies changes from committed transactions.

• Undoes changes from incomplete transactions.

• Creates a backup of the database.

• Generates a checkpoint.