Submitted Questions

  • Intent Shared Lock

    Which one of the following is descriptive of the effect of an Intent Shared Lock on other transactions? CHOICE1: A Read Lock that prevents writes CHOICE2: A Read Lock that prevents other reads CHOICE3: A Read Lock that prevents more restrictive Locks CHOICE4: A Read Lock that allows other reads CHOICE5: A Read Lock that allows writes (Dirty Reads)

    hmounir

    • May 3rd, 2010

    A Read Lock that allows other reads  Shared (S) locks allow concurrent transactions to read (SELECT) a resource under pessimistic concurrency control.No other transactions can modify the data whi...