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

Deadlocks occur when:

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.I...

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

.In a row of students, if John , who is 16th from the left, and Johnson, who is 8th from the right, interchange their positio...

Featured Courses

Popular Pages

SAT (Scholastic Assessment Test)

Reasoning special by Parwez Alam

NET

Study24x7

Defence

Henry Harvin

UPSC & State PSC

CBSE Study Materials

SSC Preparation Strategies & Study Mater...

Banking/IRDA

Get the App

Opportunity in Adversity

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

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