In the wait/die scheme,:
A) the older transaction rolls back the younger transaction and reschedules it.
B) the younger,preempted transaction is rescheduled using the same time stamp.
C) the older transaction waits for the younger one to complete and release its locks.
D) both the younger and older transactions wait indefinitely to be released.
Correct Answer:
Verified
Q47: Although the DBMS is designed to recover
Q48: A(n) _ condition occurs when two or
Q49: A lock locks the entire diskpage.
A)transaction-level
B)table-level
C)page-level
D)row-level
Q52: A lock locks the entire table preventing
Q54: A(n)phase in a two-phase lock is when
Q56: A(n)occurs when a transaction executes a query
Q56: In the optimistic approach, during the_ phase,
Q57: The objective of _ control is to
Q57: The isolation level ensures that queries return
Q59: If a(n) _ is issued before the
Unlock this Answer For Free Now!
View this answer and more for free by performing one of the following actions
Scan the QR code to install the App and get 2 free unlocks
Unlock quizzes for free by uploading documents