In context of deadlock prevention in DBMS, wait-die and wound-wait schemes are ........ techniques.
DBMS में डेडलॉक प्रिवेंशन के संदर्भ में, wait-die तथा wound-wait स्कीम ...... तकनीक है।
Pick an option to check yourself, or open the answer below.
Show answer & explanation
Correct answer: D. non-preemptive and preemptive respectivelyक्रमश: नॉन - प्रिम्पटिव तथा प्रिम्पटिव
Explanation
Wait-die: an older transaction waits for a younger one, a younger one dies — nobody is forced to give up a lock, so it is non-preemptive. Wound-wait: an older transaction wounds (rolls back) the younger holder — preemptive.
Wait-die में कोई भी ट्रांजेक्शन किसी से लॉक छीनता नहीं (नॉन-प्रिम्पटिव)। Wound-wait में पुराना ट्रांजेक्शन नए को रोलबैक करा देता है (प्रिम्पटिव)।
More Database Management & SQL questions
- In context of databases consider set operations on relation R and S, and select a true statement :
- In context of 2-phase locking protocol in DBMS, a transaction issues lock requests in ......... phase and unlock requests in ........ phase.
- Choose the SQL commands to perform following operations on a relation R : I : Retain Relation R in database, but delete all tuples in R. II…
- If the following functional dependencies holds on a selection R : A → B, A → C, BC → D, C → F, B → E, then which of the following dependenc…
- The ........... of weak entity set distinguishes among all those entities in the weak entity set that depends upon one particular strong en…
- A function that has no partial functional dependencies is in …….. form.