Suppose you are the DBA for a heavily used database where many transactions are being concurrently applied throughout the day. At 10AM you noticed that no transactions are being committed. Being the local expert, you quickly deduce the problem to a culprit transaction which is hoarding locks. It seems that the intern is inappropriately executing a huge transaction by locking all the rows within a critical Human Resources table. Describe how to use the techniques recently covered such as checkpointing, REDO, UNDO, etc to resolve the current dilemma. Make sure to explain how your DBMS is affected by being configured as immediate update or deferred update.