A transaction consists of one or more read/write operations according to certain sequence………
a) serial schedule
b) serializable transaction schedule
c) deadlock
d) lock concurrency
A plan to execute transactions serially is known as……..
a) serial schedule
b) serializable transaction schedule
c) deadlock
d) lock concurrency
Which of the following are properties of serializable schedule?
a) serializable schedule equal to serial schedule
b) no read write conflict
c) not suffer from lost update, dirty read
d) all of these
A situation in which two transactions wait for completion of each other……
a) serial schedule
b) serializable transaction schedule
c) deadlock
d) lock concurrency
How many solutions of deadlock?
a) one
b) two
c) three
d) four
Explanation: deadlock prevention, deadlock detection & recovery
Which of the following are reasons of database failure?
a) failure of computer system
b) break down of hardware
c) program bugs
d) all of these
