Question: Suppose that Session 1, Session 2, and Session 3 are sessions connected concurrently to the same database instance. Suppose further that X, Y, and Z

Suppose that Session 1, Session 2, and Session 3 are sessions connected concurrently to the same database instance. Suppose further that X, Y, and Z are data objects that can be locked with a shared and exclusive lock

it is your turn to describe what will happen in each scenario below. For each scenario, indicate, for each session, whether it procures the requested lock, waits, or deadlocks. Make sure to explain your reasoning.

Scenario 7: Session 1 has a shared lock on X and Session 2 attempts to procure an exclusive lock on X.

Scenario 8: Session 1 has a shared lock on X, Session 2 has a shared lock on X, and Session 3 attempts to procure a shared lock on X.

Scenario 9: Session 1 has an exclusive lock on X and attempts to procure an exclusive lock on Y. Session 2 has an exclusive lock on Y and attempts to procure an exclusive lock on X.

Scenario 10: Session 1 has an exclusive lock on X and a shared lock on Y, and Session 2 attempts to procure an exclusive lock on Y.

Scenario 11: Session 1 has a shared lock on X and a shared lock on Y. Session 2 has a shared lock on Y and attempts to procure an exclusive lock on X.

Scenario 12: Session 1 has a shared lock on X and attempts to procure an exclusive lock on Y. Session 2 has a shared lock on Y and attempts to procure an exclusive lock on Z. Session 3 has a shared lock on Z and attempts to procure an exclusive lock on X.

.EDIT : I need answers to scenario 7-12

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock blur-text-image

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!

This assignment verifies that you understand how shared and exclusive locks work. Suppose that Session 1, Session 2, and Session 3 are sessions connected concurrently to the same database instance....

REFERENCE CASE Starbucks: Reaffirming Commitment to the Third Place Ideal On the morning of April 12, 2019, Kevin Johnson, CEO of Starbucks, the Seattlebased coffee Chain and packaged goods purveyor,...

Category Creativity Techniques A to Z This A to Z of Creativity and Innovation Techniques, provides an introduction to a range of tools and techniques for both idea generation (Creativity) and...

This assessment task requires you to take on the role of a project management team to produce a project plan for your client. In this instance the project plan provides a detailed plan of the...

Database Administration CHAPTER OBJECTIVES I Understand the need for and importance of database I ttno'illI the meaning of ACID transaction administralin - Learn the tour 1992 ANSI standard isolation...

The new line character is utilized solely as the last person in each message. On association with the server, a client can possibly (I) question the situation with a client by sending the client's...

SAHOL paid a dividend of 4 TRY last year. The growth rate is 10% and the required rate of return is 30% . What is the intrinsic value of SAHOL share?calculate.

Discuss the concept of operating leverage.

Using the fundamental ( accounting ) approach, what is the cost of equity for this firm? Do not use CAPM, as that is the next question. 1 9 . 0 6 % 1 7 . 4 7 % 1 . 5 9 % 8 . 4 2 %

Seved Help 14 Wisconsin Snowmobile Corp. is considering a switch to level production Cost efficiencies would occur under level production, and aftertax costs would decline by $31,500, but inventory...

Imagine that the U.S. Congress, recognizing the importance of being well dressed, started giving preferential tax treatment to clothing insurance. Under this new type of insurance, you would pay the...

Find some information on an index fund (such as the Vanguard Total Stock Market Index, ticker symbol VTSMX). How has this fund performed compared with other stock mutual funds over the past 5 or 10...

According to an old myth, Native Americans sold the island of Manhattan about 400 years ago for $24. If they had invested this amount at an interest rate of 7 percent per year, how much would they...