Consider an application consisting of transactions that are assigned different isolation levels. Prove that if transaction T is executed at SERIALIZABLE and transaction T is any other transaction, then T either sees all changes made by T or it sees none.
What will be an ideal response?
Transactions executing at all the isolation levels use long term write locks, and
transactions executing at SERIALIZABLE use long term read and write locks. Hence all
operations of T are serializable with respect to the write operations of T
. Hence T either sees all the changes made by T
or none.
You might also like to view...
_________ share(s) the processing of a task across multiple computer systems
a. Distributed computing b. Supercomputers c. Enterprise servers 1.The hardware components that serve the input, output, and storage functions of a computer are called _____. a. central processing units b. control units c. peripheral devices
Early computers that held both programs and data in memory became known as ________ architecture.
Fill in the blank(s) with the appropriate word(s).