subject

Deadlocks happen when two or more access operations happen at the same time in a database. In an HR operation, the HR Clerk is trying to delete records which will then be in the job_history and update salaries that were recommended by the Director on promotion of the records deleted, while the Senior HR Officer is trying to use salaries to calculate this month’s pay out. A third operation on the salaries involves the HR Manager who wants to know who was promoted last month so that their salaries reflect correctly in this month’s payroll. a. Write out a scenario with schematics (or diagrams) to show a typical deadlock situation that would arise as a result of the scenario given. [15]
b. What granularity would you recommend to use for each of these operations, and why? [8]
c. What would a scheduler’s role be in this scenario? Which would be best according to your understanding of deadlock resolution? [4]

d. Recommend a suitable, future solution based on:
i. Optimistic Approach. [4]
ii. Pessimistic Approach. [4]

ansver
Answers: 2

Another question on Computers and Technology

question
Computers and Technology, 23.06.2019 06:30
When early motion pictures played in movie theaters, they were often accompanied by live organ or piano music. which of the following are the most likely reasons that this happened? (select all that apply). the music was provided to distract audience members from the loud sounds made when filmstrips were changed. the music accompanied the movies because the movies were silent and audiences were used to hearing music during plays in theaters. the music usually was played before, and sometimes after the movie, as an alternative form of entertainment. the music viewers to interpret the dramatic action in the films.
Answers: 2
question
Computers and Technology, 24.06.2019 03:40
4. does the kernel phenotype distribution support the idea that the cob is the result of a dihybrid cross? what information supports your answer? if a dihybrid cross (i.e. f1 to f2 of standard mendelian crosses) is not indicated what conditions might contribute to this finding.
Answers: 2
question
Computers and Technology, 24.06.2019 13:30
Consider jasper’s balance sheet. which shows how to calculate jasper’s net worth?
Answers: 1
question
Computers and Technology, 24.06.2019 21:40
Which of these is not a type of socket? aga (alternating grid array) pga (pin grid array) spga (staggered pin grid array) lga (land grid array)
Answers: 1
You know the right answer?
Deadlocks happen when two or more access operations happen at the same time in a database. In an HR...
Questions
question
Chemistry, 03.05.2021 23:50
question
World Languages, 03.05.2021 23:50
question
Mathematics, 03.05.2021 23:50
question
English, 03.05.2021 23:50