Fundamental concepts of transactions

Code No
Skill Category No: 
8
Skill No: 
1
Topic No: 
3
Level: 
I
  • The concept and features of transaction indispensable to database design.
    •  ACID
    •  Concurrent Execution
    •  Recovery
  • Concept and implementation of exclusive control.
  • Lock
    •  Shared lock
    •  Exclusive lock
    •  Deadlock
    •  2-phase lock
  • Isolation level
    • Dirty reads
    • Non-repeatable reads
    • Phantom reads
    • READ UNCOMMITTED
    • READ COMMITTED
    • REPEATABLE READ
    • SERIALIZABLE