Suppose that you are writing a stored procedure to record new purchases. Suppose that you know that while your procedure is running, another stored procedure that records shipment data can be running, and a third stored procedure that updates shipper data can also be running.

1. Give an example of a dirty read, a nonrepeatable read, and a phantom read among this group of stored procedures.

2. What concurrency control measures are appropriate for the stored procedure that you are creating?

3. What concurrency control measures are appropriate for the two other stored procedures?

Answer rating: 100% (QA)

1 Examples of concurrency issues among the three stored procedures Dirty Read A dirty read occurs when one stored procedure reads data that is being m... View the full answer