Describe how a non-recoverable situation could arise if write locks are released after the last
operation of a transaction but before its commitment.
What will be an ideal response?
An earlier transaction may release its locks but not commit, meanwhile a later transaction uses the objects and
commits. Then the earlier transaction may abort. The later transaction has done a dirty read and cannot be
recovered because it has already committed.
Computer Science & Information Technology
You might also like to view...
A keyboard ________, pressing two keys together, is used to perform actions within an application
A) grouping B) shortcut C) character D) pairing
Computer Science & Information Technology
OpenOffice Writer's Mail Merge feature can be used to create mailing labels, print envelopes,
and personalize letters and other documents. Indicate whether the statement is true or false
Computer Science & Information Technology