Ask a Question

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

in Education by
The deadlock state can be changed back to stable state by using _____________ statement. (a) Commit (b) Rollback (c) Savepoint (d) Deadlock The question was asked at a job interview. This interesting question is from Deadlocks in division Concurrency Control of Database Management Select the correct answer from above options Interview Questions and Answers, Database Interview Questions and Answers for Freshers and Experience

1 Answer

0 votes
by
The correct option is (b) Rollback The best I can explain: Rollback is used to rollback to the point before lock is obtained.

Related questions

0 votes
Q: C. Choose the right option:1. The bottom margins and top of a document can be changed by using the…….a. Spacingb. Decrease indent
    C. Choose the right option: 1. The bottom margins and top of a document can be changed by using the . a ... indent c. Increase indent Select the correct answer from above options...
asked Dec 24, 2021 in Education by JackTerrance
0 votes
Q: If pattern is to be stored, then what does stable state should have updated value of?
    If pattern is to be stored, then what does stable state should have updated value of? (a) current sate (b) next ... (d) none of the mentioned Please answer the above question....
asked Aug 30, 2022 in Education by JackTerrance
0 votes
Q: The deadlock can be handled by
    The deadlock can be handled by (a) Removing the nodes that are deadlocked (b) Restarting the search after ... , Database Interview Questions and Answers for Freshers and Experience...
asked Oct 11, 2021 in Education by JackTerrance
0 votes
Q: The deadlock in a set of a transaction can be determined by
    The deadlock in a set of a transaction can be determined by (a) Read-only graph (b) Wait graph ( ... Answers, Database Interview Questions and Answers for Freshers and Experience...
asked Oct 11, 2021 in Education by JackTerrance
0 votes
Q: The system has entered an undesirable state (for example, deadlock), as a result of which a transaction cannot continue with its normal execution. This is
    The system has entered an undesirable state (for example, deadlock), as a result of which a ... Failure Classification in division Recovery System of Database Management...
asked Oct 10, 2021 in Education by JackTerrance
0 votes
Q: By using which method, boltzman machine reduces effect of additional stable states?
    By using which method, boltzman machine reduces effect of additional stable states? (a) no such method exist (b) ... d) none of the mentioned Please answer the above question....
asked Aug 27, 2022 in Education by JackTerrance
0 votes
Q: Multiple objects can be de parsed at once and read back using function _____
    Multiple objects can be de parsed at once and read back using function _____ (a) source() (b) read() ( ... Operations of R Programming Select the correct answer from above options...
asked Feb 15, 2022 in Education by JackTerrance
0 votes
Q: When are stable states reached in energy landscapes, that can be used to store input patterns?
    When are stable states reached in energy landscapes, that can be used to store input patterns? (a) mean of peaks and ... (d) none of the mentioned Please answer the above question....
asked Sep 3, 2022 in Education by JackTerrance
0 votes
Q: Before a block of data in main memory can be output to the database, all log records pertaining to data in that block must have been output to stable storage. This is
    Before a block of data in main memory can be output to the database, all log records pertaining to ... Buffer Management topic in chapter Recovery System of Database Management...
asked Oct 10, 2021 in Education by JackTerrance
0 votes
Q: While using a Write Back cache, which of the following policies needs to be abided?
    While using a Write Back cache, which of the following policies needs to be abided? (i)No Write Allocate (ii)Write Allocate (iii)Write Around (iv)Write Through...
asked Oct 7, 2020 in Technology by JackTerrance
0 votes
Q: Explain What should not be done to avoid deadlock?
    What should not be done to avoid deadlock? (a) Avoid using multiple threads (b) Avoid hold several locks ... Multithreading of Java Select the correct answer from above options...
asked Mar 1, 2022 in Education by JackTerrance
0 votes
Q: What should not be done to avoid deadlock?
    What should not be done to avoid deadlock? (a) Avoid using multiple threads (b) Avoid hold several ... Questions for Interview, JavaScript MCQ (Multiple Choice Questions)...
asked Oct 24, 2021 in Education by JackTerrance
0 votes
Q: The __________ icon on a slide can not be changed and resized . Fill in the blanks.
    The __________ icon on a slide can not be changed and resized . Fill in the blanks. Select the correct answer from above options...
asked Dec 23, 2021 in Education by JackTerrance

© Copyright 2018-2023 www.Blogmepost.com. All rights reserved. Developed by Blogmepost.

...