The deadlock state can be changed back to stable state by using _____________ statement. Options: A . &nbspCommit B . &nbspRollback C . &nbspSavepoint D . &nbspDeadlock

The deadlock state can be changed back to stable state by using ____________

Question

The deadlock state can be changed back to stable state by using _____________ statement.

Options:

A . Commit

B . Rollback

C . Savepoint

D . Deadlock

Answer: Option B

RollbackRollback is used to rollback to the point before lock is obtained.

Was this answer helpful ?

Next Question

Question 1. What are the ways of dealing with deadlock ? ....

Question 2. When transaction Ti requests a data item currently held by Tj , Ti is allowed to wait only if it has a timestamp smalle....Tj ). Otherwise, Ti is rolled back (dies). This is

Question 3. When transaction Ti requests a data item currently held by Tj , Ti is allowed to wait only if it has a timestamp larger....rolled back (Tj is wounded by Ti ). This is

Question 4. The deadlock in a set of transaction can be determined by ....

Question 5. A deadlock exists in the system if and only if the wait-for graph contains a ___________. ....

Question 6. Which of these is data type long literal? ....

Question 7. Selecting the victim to be rollbacked to the previous state is determined by the minimum cost. The factors determining ....the minimum cost. The factors determining cost of rollback is

Question 8. __________ rollback requires the system to maintain additional information about the state of all the running transacti....additional information about the state of all the running transactions.

Chapter 1 - GLOBAL STEEL SCENARIO & INDIAN STEEL INDUSTRY Part 1 : (13-04-2024) INDUSTRY AND COMPANY AWARENESS (ICA)

Direction Sense Test Part 1 Reasoning (Hindi)

Chapter 1 - RMHP / OHP / OB & BP Part 1 : (14-02-2024) GPOE

Cube & Cuboid Part 1 Reasoning (Hindi)

Data Interpretation (DI) Basic Concept Reasoning (Hindi)

Counting Figures Part 1 Counting Of Straight Lines Reasoning (Hindi)

Sail E0 free webinar Webinars

Real Numbers Part 7 Class 10 Maths

Real Numbers Part 1 Class 10 Maths

Polynomials Part 1 Class 10 Maths

DSP Combined 1 Free Revision Test SAIL JO E-0

GPOE / GPA Combined 1 Free Revision Test SAIL JO E-0

BSP Plant Specific Review Test SAIL JO E-0

BSL Combined 1 Free Revision Test SAIL JO E-0

GFM Combined 1 Free Revision Test SAIL JO E-0