Lock Requests
When either a statement or a command is issued, implicit requests for locks are made. The locking system also determines what mode and level of lock to take by considering the following factors:
• Are there any locks available in the system?
• Does the query involve reading or updating data?
• What resources are affected by the query?
• Are any other locks held on the affected resources?