Recall that a shared lock may be held by several transactions, while an exclusive lock can be held by only one transaction. Consider two systems
• System A uses shared and exclusive locks.
• System B uses only exclusive locks.
Then,

Question

Recall that a shared lock may be held by several transactions, while an exclusive lock can be held by only one transaction. Consider two systems 
 • System A uses shared and exclusive locks. 
 • System B uses only exclusive locks. 
 Then,

Accepted Answer

If all transactions are read-only, then on system A no transaction ever waits.

Accepted Answer

System A may be able to execute more transactions per second than system B.

Answer

If all transactions are write-only, then on system B no transaction ever waits.

Answer

There exists schedules that result in a deadlock on system A but not in a deadlock on system B.

Crowdly

Recall that a shared lock may be held by several transactions, while an exclusiv...

Want instant access to all verified answers on moodlenew.iitd.ac.in?