• DIRTY READ: Dirty Read Reads the data without checking whether the data is committed or not. During the read, no locks are held.
  • COMMITTED READ: Committed Read reads only the determined data. During the read, no locks are held.
  • REPEATABLE READ: Reads only the committed data. In this read, a shared lock is held on the rows. Other sessions can get the shared locks on those rows, but no one can get an exclusive lock.
  • CURSOR STABILITY
BY Best Interview Question ON 08 Feb 2019