deadlock Avoidance –When a database is stuck in a deadlock, It is always better to avoid the deadlock rather than restarting or aborting the database. Deadlock avoidance method is suitable for smaller database whereas deadlock prevention method is suitable for larger database.One method of avoiding deadlock is using application consistent logic. In the above given example, Transactions that access Students and Grades should always access the tables in the same order. In this way, in the scenario described above, Transaction T1 simply waits for transaction T2 to release the lock on Grades before it begins. When transaction T2 releases the lock, Transaction T1 can proceed freely

Question

deadlock Avoidance –When a database is stuck in a deadlock, It is always better to avoid the deadlock rather than restarting or aborting the database. Deadlock avoidance method is suitable for smaller database whereas deadlock prevention method is suitable for larger database.One method of avoiding deadlock is using application consistent logic. In the above given example, Transactions that access Students and  Grades should always access the tables in the same order. In this way, in the scenario described above, Transaction T1 simply waits for transaction T2 to release the lock on  Grades before it begins. When transaction T2 releases the lock, Transaction T1 can proceed freely

trilok sharma · Accepted Answer

deadlock Avoidance –When a database is stuck in a deadlock, It is always better to avoid the deadlock rather than restarting or aborting the database. Deadlock avoidance method is suitable for smaller database whereas deadlock prevention method is suitable for larger database.One method of avoiding deadlock is using application consistent logic. In the above given example, Transactions that access Students and  Grades should always access the tables in the same order. In this way, in the scenario described above, Transaction T1 simply waits for transaction T2 to release the lock on  Grades before it begins. When transaction T2 releases the lock, Transaction T1 can proceed freely

[What is a deadlock in the context of transaction management?]

[In the context of concurrency control, what does the term deadlock refer to?]

[In the case of deadlock between the two houses parliament, the joint sitting is presided over by the:]

[Q. In the case of deadlock between the two houses parliament, the joint sitting is presided over by the:]

[According to a proverb, what is said to be ‘the mother of invention’ ?]

[.Select the related word/letters/numbers from the given alternatives:42 : 56 :: 110 : ?]

[. For the following questionsFind the odd word/letters/number from the given alternatives.Options:]

[For the following questionsFind the odd word/letters/number from the given alternatives.Options:]

[.A series is given, with one term missing. Choose the correct alternative from the given ones that will complete the series....

[.A series is given, with one term missing. Choose the correct alternative from the given ones that will complete the series....

Featured Courses

Popular Pages

SAT (Scholastic Assessment Test)

NET

Reasoning special by Parwez Alam

Defence

Study24x7

UPSC & State PSC

Henry Harvin

CBSE Study Materials

SSC Preparation Strategies & Study Mater...

Banking/IRDA

Get the App

[Opportunity in Adversity]

[Preparation Strategy for Computer Science Engineering (CSE-...

[Trends in a GATE Exam]

[All You Need To Know About GATE Exam]

[The Application Process For GATE Exam]

[Benefits of Clearing a GATE Exam]

[Things you need to Know about GATE Scores]

[Common Mistakes People make while Preparing for GATE Exams]

[Preparation Strategy for Mechanical Engineering (GATE)]

[Overview of PSU Examination]