Which of the following correctly describe the locking mechanism in a RDBMS?

  1. A read lock prevents other transactions from reading the locked data

  2. A write lock prevents other transactions from reading or writing to the locked data

  3. Multiple transactions can have write locks on the same data item.

  4. Multiple transactions can have read locks on the same data item.

  5. Either B&D


Correct Option: E

Find more quizzes: