What is the primary purpose of the "No-Wait" locking strategy in database systems?To ensure that transactions wait indefinitely for locks to ensure data integrity.To allow transactions to abort immediately if the required locks cannot be acquired instantly.To prioritize lock requests based on the duration a transaction has been waiting.To escalate locks from shared to exclusive mode more rapidly.

In which scenario is a "High Granularity Lock" preferred in a database system?When transactions frequently access a small number of rows within a table.When transactions require access to large portions of the database, such as entire tables or indexes.When the overhead of lock management is negligible compared to transaction execution time.When the database system prioritizes read operations over write operations.

In the context of locking, what is an Exclusive Lock used for?Allows multiple transactions to write simultaneouslyPrevents multiple transactions from writing simultaneouslyAllows multiple transactions to read simultaneouslyPrevents multiple transactions from reading simultaneously

What is the purpose of the Lock class in the threading module?

Which modification of the Two-Phase Locking Protocol requires transactions to hold all locks until they commit or abort?

n a database system employing both pessimistic and optimistic concurrency control mechanisms, which of the following scenarios would typically be handled more efficiently by optimistic concurrency control?A high volume of transactions where most of them update a common set of data.Transactions that are mostly read-only and seldom update the database.Transactions in a banking system where account balances are frequently updated.