Which of the following schemes allows an older transaction to wait for a younger transaction? A) Wound-Wait B) Wait-Die C) Both D) None

B) Wait-Die

Fill in the blank: The property that ensures a transaction's changes are permanent even in the event of a system failure is called ______.

Durability

True or False: Starvation in a database occurs when a transaction can proceed without any waiting.

False. Starvation occurs when a transaction cannot proceed for an indefinite time because of resource allocation issues.

What is the main purpose of a Lock Manager in DBMS?

To manage locking and unlocking of data items requested by transactions.

Riddle: I am a protocol that guarantees that transactions can execute without interference, and I come in four levels. What am I?

Transaction Isolation Levels

Which protocol ensures that all exclusive locks must be released after a transaction commits?

Strict Two-Phase Locking (Strict 2-PL)

Fill in the blank: The algorithm used to check for cycles in a set of transactions is called ______.

Wait-for-Graph

True or False: Deadlock detection requires a system to actively monitor transactions for potential deadlocks.

True.

What is the primary method used to handle transaction failures in a DBMS?

Database Recovery Techniques

What is the primary characteristic of a recoverable schedule in DBMS?

A recoverable schedule ensures that transactions only commit after all transactions whose changes they read have committed.