Discuss Optimistic vs. Pessimistic Locking

Question Explain

Explain the difference between optimistic locking (version numbers) and pessimistic locking (database transactions). Discuss use cases where each is appropriate for concurrency control.