2 Types of Locks
Exclusive - for UPDATE, INSERT, and DELETE (write operations) - no other transaction can acquire lock until original is released
Shared - applied during non-update or read operations - usually SELECT - prevents write operations from acquiring lock - allows other read operations to share lock