Give an example of a schedule of consistent transactions that is not serializable but maintains the correctness of any integrity constraint that might conceivably be associated with the database.
What will be an ideal response?
The schedule contains a lost update. For example,
r1(x) r2(x) w2(x) w1(x)
T2’s update is lost, and the result of the schedule is the same as if only T1 had
executed and T2 had never executed. Since T1 is assumed to be consistent, the
schedule maintains all possible integrity constraints. However, the final database might
be incorrect. since T2’s update has been lost
You might also like to view...
The “per inch” in the units dots per inch and pixels per inch is in _____.
A. square inches B. linear inches
One of the most important utility software packages for any computer connected to the Internet is ________.
a. antivirus software b. accessories software c. backup software d. an Internet browser
____ is a PC operating system developed by Google to work with Google web applications.
A. Windows B. macOS C. Linux D. Chrome OS
One of the most obvious types of hardware loss is hardware theft. _________________________
Answer the following statement true (T) or false (F)